Re: Changing the DataSource in a loop
- From: "Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx>
- Date: Thu, 30 Jun 2005 20:52:12 +0100
Chance are you are not closing the connection in the workflow properties
each time
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"JvCoach23" <jvcoach23@xxxxxxxxxxx> wrote in message
news:1120138657.415629.304620@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> I'm trying to change the datasource for a dts package inside of a loop.
> I've created a dyanmic proprety that is housed inside the looping steps
> that has the datasource = value of a global variable. In the workflow
> active x for the dynamic properties i add a
> msgbox(DTSGlobalVariables("CurrentDSN").Value). This value changes
> each time through the loop correctly, but the datasource seems not to
> change. I am checking this by doing a step right after the dynamic
> that does a count. The count for the first value assigned is 335, the
> second time through hitting the second data source value should be 901,
> but it is 335. I am not sure what i'm doing wrong that the value
> doesn't stick.
>
> Please help
> thanks
> shannon
>
.
- References:
- Changing the DataSource in a loop
- From: JvCoach23
- Changing the DataSource in a loop
- Prev by Date: Re: Using 'Execute SQL Task' to insert rows
- Next by Date: Re: SSIS - How to use the old DTSStepScriptResult_DontExecuteTask?
- Previous by thread: Re: Changing the DataSource in a loop
- Next by thread: Using 'Execute SQL Task' to insert rows
- Index(es):
Relevant Pages
|
