Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: SQLSSISDev
- Order by date
-
how to make my SSIS package execute successfully, even when there is no input feed file.
Hello, Currently I am running a SSIS package scheduled daily at 7 A.M. It expects two feed files from two different folders. The first step in my package will rename the input files in those folders to names which the package can understand. I have created two variables in my package to read...- SQLSSISDev
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
How to make SSIS packages automatically read the input file from a path?
Hello gk53, Thanks for the heads up. However, I have no idea as to how to start doing it. I mean like, where to create a variable?, using what (tool/editor/etc)?, etc Could you please have some patience and let me know the steps to do it? Thank you.- SQLSSISDev
- Post #3
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
How to make SSIS packages automatically read the input file from a path?
Currently I am using a SSIS package to read data from a .dat file and load it into SQL Server tables. I am placing the input .dat file on the desktop. In the connection manager -> Browse option, I am pointing this file to create connection. The file naming convention is like -...- SQLSSISDev
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Integration Services (SSIS)
