 | |
cant assign filename in DTS
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
cant assign filename in DTS -
11-09-2004
, 11:10 AM
#2
| |||
| |||
|
|
Ive got a dts package that: Has a string Global Variable. In an active X Script, opens a message box to accept a file path and name. In a Dynamic Props Task, assigns that file path and name to the Global Variable. Imports data from a .txt file into an SQL table. So in this particular package, the filename and path are fed in at time of execution. Its been working for quite some time. But now Im trying to create another package that does the same thing and its not working. It keeps pointing to the original file that was used the first time even though I put the new file name in at time of execution. I can verify that the file name is being assigned properly by looking in the Dynamic Props Task/ Edit/ Connections/ OLE DB Props/ Data Source/ Set/ Preview tab. But still, it points to the old file. All idas are appreciated. -- SQL2K SP3 TIA, ChrisR |
#3
| |||
| |||
|
|
Have you set "Close Connection On Completion" in the workflow properties? -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.Konesans.com "ChrisR" <bla (AT) noemail (DOT) com> wrote in message news:ef%23%23%237nxEHA.3976 (AT) TK2MSFTNGP09 (DOT) phx.gbl... Ive got a dts package that: Has a string Global Variable. In an active X Script, opens a message box to accept a file path and name. In a Dynamic Props Task, assigns that file path and name to the Global Variable. Imports data from a .txt file into an SQL table. So in this particular package, the filename and path are fed in at time of execution. Its been working for quite some time. But now Im trying to create another package that does the same thing and its not working. It keeps pointing to the original file that was used the first time even though I put the new file name in at time of execution. I can verify that the file name is being assigned properly by looking in the Dynamic Props Task/ Edit/ Connections/ OLE DB Props/ Data Source/ Set/ Preview tab. But still, it points to the old file. All idas are appreciated. -- SQL2K SP3 TIA, ChrisR |
#4
| |||
| |||
|
|
Where would I find that option? I went to Package/ Props and its not there that I can see. "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:u3$b29pxEHA.908 (AT) TK2MSFTNGP11 (DOT) phx.gbl... Have you set "Close Connection On Completion" in the workflow properties? -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.Konesans.com "ChrisR" <bla (AT) noemail (DOT) com> wrote in message news:ef%23%23%237nxEHA.3976 (AT) TK2MSFTNGP09 (DOT) phx.gbl... Ive got a dts package that: Has a string Global Variable. In an active X Script, opens a message box to accept a file path and name. In a Dynamic Props Task, assigns that file path and name to the Global Variable. Imports data from a .txt file into an SQL table. So in this particular package, the filename and path are fed in at time of execution. Its been working for quite some time. But now Im trying to create another package that does the same thing and its not working. It keeps pointing to the original file that was used the first time even though I put the new file name in at time of execution. I can verify that the file name is being assigned properly by looking in the Dynamic Props Task/ Edit/ Connections/ OLE DB Props/ Data Source/ Set/ Preview tab. But still, it points to the old file. All idas are appreciated. -- SQL2K SP3 TIA, ChrisR |
#5
| |||
| |||
|
|
Right click on the task ( the black line in the Transform Data task) and do Workflow Properties | Options -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.Konesans.com "ChrisR" <bla (AT) noemail (DOT) com> wrote in message news:OG$KvTqxEHA.3224 (AT) TK2MSFTNGP14 (DOT) phx.gbl... Where would I find that option? I went to Package/ Props and its not there that I can see. "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:u3$b29pxEHA.908 (AT) TK2MSFTNGP11 (DOT) phx.gbl... Have you set "Close Connection On Completion" in the workflow properties? -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.Konesans.com "ChrisR" <bla (AT) noemail (DOT) com> wrote in message news:ef%23%23%237nxEHA.3976 (AT) TK2MSFTNGP09 (DOT) phx.gbl... Ive got a dts package that: Has a string Global Variable. In an active X Script, opens a message box to accept a file path and name. In a Dynamic Props Task, assigns that file path and name to the Global Variable. Imports data from a .txt file into an SQL table. So in this particular package, the filename and path are fed in at time of execution. Its been working for quite some time. But now Im trying to create another package that does the same thing and its not working. It keeps pointing to the original file that was used the first time even though I put the new file name in at time of execution. I can verify that the file name is being assigned properly by looking in the Dynamic Props Task/ Edit/ Connections/ OLE DB Props/ Data Source/ Set/ Preview tab. But still, it points to the old file. All idas are appreciated. -- SQL2K SP3 TIA, ChrisR |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.