 | |
Dynamic input file
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Dynamic input file -
04-26-2005
, 02:52 PM
#2
| |||
| |||
|
|
Hi, Does the "Dir" function work in DTS VB Script language (SQL2kServer) ? If not how can i put all the files contain in a directory as input file ? Rgds |
#3
| |||
| |||
|
|
Are you looking for something like this Looping, Importing and Archiving (http://www.sqldts.com/default.aspx?246) -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.SQLIS.com - SQL Server 2005 Integration Services. www.Konesans.com "Flora Pho" <FloraPho (AT) discussions (DOT) microsoft.com> wrote Hi, Does the "Dir" function work in DTS VB Script language (SQL2kServer) ? If not how can i put all the files contain in a directory as input file ? Rgds |
#4
| |||
| |||
|
|
It's quite what i want but is there a more simple way to do it using Dynamic Task Properties ? "Allan Mitchell" wrote: Are you looking for something like this Looping, Importing and Archiving (http://www.sqldts.com/default.aspx?246) -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.SQLIS.com - SQL Server 2005 Integration Services. www.Konesans.com "Flora Pho" <FloraPho (AT) discussions (DOT) microsoft.com> wrote Hi, Does the "Dir" function work in DTS VB Script language (SQL2kServer) ? If not how can i put all the files contain in a directory as input file ? Rgds |
#5
| |||
| |||
|
|
It's quite what i want but is there a more simple way to do it using Dynamic Task Properties ? "Allan Mitchell" wrote: Are you looking for something like this Looping, Importing and Archiving (http://www.sqldts.com/default.aspx?246) -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.SQLIS.com - SQL Server 2005 Integration Services. www.Konesans.com "Flora Pho" <FloraPho (AT) discussions (DOT) microsoft.com> wrote Hi, Does the "Dir" function work in DTS VB Script language (SQL2kServer) ? If not how can i put all the files contain in a directory as input file ? Rgds |
#6
| |||
| |||
|
|
On saying that. If all you wanted was one file then you would need to populate something else with the name of that file. The DP task would then look to that external source. The "something else" could be an INI file, a table an Environment variable. -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.SQLIS.com - SQL Server 2005 Integration Services. www.Konesans.com "Flora Pho" <FloraPho (AT) discussions (DOT) microsoft.com> wrote It's quite what i want but is there a more simple way to do it using Dynamic Task Properties ? "Allan Mitchell" wrote: Are you looking for something like this Looping, Importing and Archiving (http://www.sqldts.com/default.aspx?246) -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.SQLIS.com - SQL Server 2005 Integration Services. www.Konesans.com "Flora Pho" <FloraPho (AT) discussions (DOT) microsoft.com> wrote Hi, Does the "Dir" function work in DTS VB Script language (SQL2kServer) ? If not how can i put all the files contain in a directory as input file ? Rgds |
|
« 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.