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

Question

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

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

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

Elliott Whitlow SSC Guru Points: 102296 More actions · Answer 1

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

fabulous617 Old Hand Points: 329 More actions · Answer 2

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

fabulous617 Old Hand Points: 329 More actions · Answer 3

Sorry about that didn't realize I was hijacking.

Already started the thread.

Thanks for the heads up.

Elliott Whitlow SSC Guru Points: 102296 More actions · Answer 4

Ok, I see it now.

For anyone looking for it, it is at:

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

CEWII