Maybe, but unfortunately I don't have any information on that.

CEWII

So this is a one-time thing. I would definitely use SSIS to do this.

CEWII

You can't..

http://msdn.microsoft.com/en-us/library/ms139836.aspx

Important text in the article:

You cannot connect to a password-protected Excel file.

CEWII

You have to do it as a derived column. But I think you have a larger problem. It is difficult to use a sproc as a source of...

I take it you mean this line:

Int32.Parse(datareader.Item(2).ToString())

Why don't you add a msgbox and just see what you get from datareader.Item(2) before you try to manipulate it, then add the...

How do you intend to invoke (start) the SSIS package, SQL Agent Job, object model, command line?

CEWII

Try a RAISERROR statement, I'm thinking that the non-zero return doesn't matter to SSIS, but an error would..

CEWII

First of all what statement is generating the error?

Second, I *think* that ODBC connections are wrapped in an .Net wrapper for SSIS. So I might have led...

I'm betting that the connection is an OLEDB and not a SQL connection. I think you probably need to use the OLEDB objects and not the SQL objects.

CEWII

I'm still questioning whether this is the right path. Can you explain to us why you are wanting to copy up to 9.5M rows instead of using a view?

You...

Assuming SQL server is the source and destination..

You could do this pretty easily with an SSIS and I would expect it to be faster.

But I'm having a little trouble with...

If you post some of the output we might be able to help you. Right, now it is effectively, it sort of works but stops working can you tell...

Great, glad to be of assistance.

CEWII

Matt Miller (#4) (3/18/2010)

---

Elliott W (3/18/2010)

---

Before saying "don't use SSIS for this" you need to ask more questions. The biggest one is how much data are we talking about?

Lets...

Before saying "don't use SSIS for this" you need to ask more questions. The biggest one is how much data are we talking about?

Lets say 100,000 rows. I...