February 29, 2012 at 11:17 am
This may be a really stupid question, but I just cannot figure out!
My problem is in regards to reading a flat file source from a deployed SSIS package.
Obviously, when I use a flat file source (.csv file in this case), I can build the SSIS package in VS 2008 and point the source file to a location on my local machine (ie. C:\Source.csv). However, when I build/deploy the package to my SQL Sever the package cannot find the flat file source at run time (obviously, as the file is on my own machine). I have tried placing the same file on the sql server at the same file location but to no avail. Please tell me I'm doing something really stupid and this is a simple fix.
Thanks to anyone who can assist! I'm working in SQL Server 2008.
March 3, 2012 at 8:55 pm
I think you can try creating a config file and specify the location of your file in the config file. You will get lots of articles from Google on how to add config files on ssis packages and how to specify the details on config file. ssis package will read these values from config file on runtime.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply