Post reply

SSIS Package to Import Image Type Data with Fast to a Remote Database Server

  • October 18, 2011 at 9:20 am

    #1396072

    My advice is start a new thread don't hijack one. Once thats done we can see about an answer. This thread is 18months old, lets let it be.

    CEWII

  • October 18, 2011 at 9:54 am

    #1396127

    Hello all,

    I was reading the previous posts and have a similar issue. I am new to SSIS and SQL Server in general.

    I created a basic package where my Control Form consists of an "Execute SQL Task" and "Data Flow Task". My SQL task consist of

    CREATE TABLE "PLUGSSIS" (

    "JOB_NAME" VARCHAR2(50),

    "JOB_ID" VARCHAR2(22),

    "ACCT_NO" VARCHAR2(50)

    )

    My Data Flow consists of Source Connection (Excel Spreadsheet), Data Conversion, and OLE DB Destination.

    Simply I am just pushing data over a WAN from an excel spreadsheet into an oracle server. I was successful at doing this but it took about 30 minutes to upload 2000 rows to the server. Any ideas as to how I can increase the performance?

    FYI - I am currently using SQL Server 2008 R2, SQL Management Studio and Visual Studio 2008

    Any information is greatly appreciated.

    Thanks.

    Fab

  • October 18, 2011 at 10:07 am

    #1396154

    Sorry about that didn't realize I was hijacking.

    Already started the thread.

    Thanks for the heads up.

  • October 18, 2011 at 10:24 am

    #1396172

    Ok, I see it now.

    For anyone looking for it, it is at:

    http://www.sqlservercentral.com/Forums/Topic1192171-1292-1.aspx

    CEWII

Viewing 4 posts - 16 through 18 (of 18 total)

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