September 28, 2008 at 11:48 am
Is it possible to use connection manager to connect to the server where my flat file is placed on and build a package to load this file into my database table using SSIS?
Faye
September 29, 2008 at 12:57 am
Hello,
Possibly easies to start off with the Import Wizard to create the SSIS package, afterwards you can customise it as you wish.
The Wizard gives you the chance to both, select a Flat File data source for import and to save the import steps as an SSIS package.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
September 30, 2008 at 7:09 am
If you are a newbie have a look at SQL Server 2005 books online, it will give you good idea of how to import/export data
October 1, 2008 at 8:37 am
Yes, as long as the account the SSIS package is running under has permissions to read from the server in question, for example if running under VS then your account would need access to the relevant server, if running under agent then agent would need to be running under a domain account with access rights to the other server.
October 2, 2008 at 6:13 pm
Thanks. I figured it out. I put the text file on my computer then when building the SSIS package instead of using SQL Server connection I used OLE DB connection and I pointed to the production server remotely. That worked.
Faye
October 21, 2008 at 8:51 am
please i didn't understand what did u do,
I am facing the same problem and I have to get the flat file from other server and I need to get the file dynamicly according to date.
January 22, 2009 at 8:16 am
In the Flat File Connection Manager Editor specify a fully qualified file name: \\server\share\directoryame.ext
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply