Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2010
    Posts
    26

    Unanswered: Suggestions? - SSIS export then import data from stored procedure

    Hi All,

    I just wanted to get some best practices advice; I have a db which I need to export the data from one table (daily, via SSIS probably) to an ftp site where it will be imported (via SSIS, likely) into another SQL db.

    My boss is a little old fashioned and doesnt want it done with SSIS's ability to copy db objects, so my thought lean towards CSV and XML files.

    Does anyone have any similar experiences that they would share, or suggestions one way or another with import / export via SSIS?

    Thanks!

    D
    Last edited by dah97765; 02-21-11 at 19:59.

  2. #2
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    BCP - One way is to export/import using bcp. I use SSIS tasks to do these imports/exports also. Not much of an issue. Can include an FTP task. What else would you like to know?

  3. #3
    Join Date
    Aug 2010
    Posts
    26
    Quote Originally Posted by corncrowe View Post
    BCP - One way is to export/import using bcp. I use SSIS tasks to do these imports/exports also. Not much of an issue. Can include an FTP task. What else would you like to know?
    Thanks for the reply. Do you use bcp in this way?

    Creating CSV Files Using BCP and Stored Procedures

  4. #4
    Join Date
    Aug 2010
    Posts
    26
    I ended up using SSIS and it workes pretty well for my needs. I'm now going to attempt to introduce DTS config files to make it more generic.

  5. #5
    Join Date
    Aug 2010
    Posts
    26
    Just as an FYI for those who are also attempting something similar:

    I was able to effectively use dtsconfig files for controlling my SSIS packages. The process is rather straightforward once you know where it is. A helpful guide is here:

    Making SSIS Packages portable - SQL Server 2005 Integration Services : Narayana Vyas Kondreddi's home page

    Thanks!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •