 | |
Text File Connection ... can it be dynamic
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Text File Connection ... can it be dynamic -
05-04-2005
, 03:14 PM
#2
| |||
| |||
|
|
I am trying to figure out if I can build a dynamic text file connection in the DTS Designer. The datasource will be a text file, but the name will change... Any pointer or links to articles would be helpful... Thanks |
#3
| |||
| |||
|
|
Then this should help you How can I change the filename for a text file connection? (http://www.sqldts.com/default.aspx?200) -- 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 "Warren" <Warren (AT) discussions (DOT) microsoft.com> wrote I am trying to figure out if I can build a dynamic text file connection in the DTS Designer. The datasource will be a text file, but the name will change... Any pointer or links to articles would be helpful... Thanks |
#4
| |||
| |||
|
|
Then this should help you How can I change the filename for a text file connection? (http://www.sqldts.com/default.aspx?200) -- 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 "Warren" <Warren (AT) discussions (DOT) microsoft.com> wrote I am trying to figure out if I can build a dynamic text file connection in the DTS Designer. The datasource will be a text file, but the name will change... Any pointer or links to articles would be helpful... Thanks |
#5
| |||
| |||
|
|
The issue I am trying to figure out is that I will not know the name of the file on the remote server until I connect to it. I will open a connection to the remote Server, look into a directory. I will then see anywhere from 1 to several files, I will then need to download each file and DTS the info in each one for our database. I was first thinking I could get a list of the files from the remote server. (Have to figure out how to do that via SQL Server or similar means...) Once I have that I would iterate through each file and delete them when i was done.. "Allan Mitchell" wrote: Then this should help you How can I change the filename for a text file connection? (http://www.sqldts.com/default.aspx?200) -- 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 "Warren" <Warren (AT) discussions (DOT) microsoft.com> wrote I am trying to figure out if I can build a dynamic text file connection in the DTS Designer. The datasource will be a text file, but the name will change... Any pointer or links to articles would be helpful... Thanks |
#6
| |||
| |||
|
|
Then can you not use 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 "Warren" <Warren (AT) discussions (DOT) microsoft.com> wrote The issue I am trying to figure out is that I will not know the name of the file on the remote server until I connect to it. I will open a connection to the remote Server, look into a directory. I will then see anywhere from 1 to several files, I will then need to download each file and DTS the info in each one for our database. I was first thinking I could get a list of the files from the remote server. (Have to figure out how to do that via SQL Server or similar means...) Once I have that I would iterate through each file and delete them when i was done.. "Allan Mitchell" wrote: Then this should help you How can I change the filename for a text file connection? (http://www.sqldts.com/default.aspx?200) -- 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 "Warren" <Warren (AT) discussions (DOT) microsoft.com> wrote I am trying to figure out if I can build a dynamic text file connection in the DTS Designer. The datasource will be a text file, but the name will change... Any pointer or links to articles would be helpful... Thanks |
#7
| |||
| |||
|
|
Unless I am reading this wrong, this is a fso which does not support FTP... Since I have to connect to a remote server via FTP, I cannot use the FSO tools... "Allan Mitchell" wrote: Then can you not use 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 "Warren" <Warren (AT) discussions (DOT) microsoft.com> wrote The issue I am trying to figure out is that I will not know the name of the file on the remote server until I connect to it. I will open a connection to the remote Server, look into a directory. I will then see anywhere from 1 to several files, I will then need to download each file and DTS the info in each one for our database. I was first thinking I could get a list of the files from the remote server. (Have to figure out how to do that via SQL Server or similar means...) Once I have that I would iterate through each file and delete them when i was done.. "Allan Mitchell" wrote: Then this should help you How can I change the filename for a text file connection? (http://www.sqldts.com/default.aspx?200) -- 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 "Warren" <Warren (AT) discussions (DOT) microsoft.com> wrote I am trying to figure out if I can build a dynamic text file connection in the DTS Designer. The datasource will be a text file, but the name will change... Any pointer or links to articles would be helpful... Thanks |
#8
| |||
| |||
|
|
Trying to figure out this code sample: http://www.sqldts.com/default.aspx?302 Has anyone used this ? "Allan Mitchell" wrote: Then this should help you How can I change the filename for a text file connection? (http://www.sqldts.com/default.aspx?200) -- 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 "Warren" <Warren (AT) discussions (DOT) microsoft.com> wrote in message news:2BBA1D04-7025-4810-956D-E2116E35AC5E (AT) microsoft (DOT) com... I am trying to figure out if I can build a dynamic text file connection in the DTS Designer. The datasource will be a text file, but the name will change... Any pointer or links to articles would be helpful... Thanks |
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
|
« 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.