Post reply

csv file to another server

  • September 19, 2012 at 9:14 am

    #281786

    How are different ways to task i can use to load csv file to different server in ssis.I have created a package which is loading data from table to csv file.It is simple package having oledb connection and flat file connection.I want to load data which is in table from one server(A) to another server(B) in the format of csv file.where i should enter 2nd server name or do i need to use file system or any other flow task?.

    Thanks a lot!

  • September 19, 2012 at 9:16 am

    #1539626

    What is the reasoning behind exporting the data to csv then importing it again?

    Essentially the method is the same as the export just reversed, so you would have a connection manager to the file and a connection manager to serverB with a data flow task which takes data from the file and puts it into the database.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply