Any idea on what kind of object it fails?

hoolash (11/17/2013)

---

Thanks mister.magoo and bitbucket! Wow, I didn't know it was so complex to do that! SQL Server being a Microsoft product (same as Excel), I believe there should have...

Nice question, thanks.

This article explains it pretty much:

Introducing the Foreach Loop Container[/url]

blasto_max (11/17/2013)

---

I have a string variable which stores a big set of sql statements, ie insert statements. The insert statement intends to inserts about 200K rows with 10 columns (Lots...

Giving the service account permissions, would mean that all the jobs executed by that service accounts have permission to everything.

Found the issue. Found a log file in \AppData\Local\Temp, called SqlSetup.log

Most important line was:

A quick google search told me to reset the .NET...

Not that I know of.

I said a "decent" text editor.

Try notepad++ and configure it to show all symbols.

Maybe you are missing some row delimiters or something like that.

Seems there are some issues with your file.

Those don't sound good. Open the CSV file with a decent text editor and look for anomalies.

Very interesting question, thanks.

It seems the test you did was twice the same folder, but with different notations. The folder was each time on the local server.

If you move the SSIS package to...

Did you read the MSDN article I linked to?

Yes.

Upgrade to a Different Edition of SQL Server 2012

You should worry more about migrating SQL 2000 to SQL 2012 instead of the editions.

Great question, thanks.