Nice question Steve, Thanks for sharing !!!

Ratheesh.K.Nair (8/21/2014)

---

The server where...

This question have been answered over here

Just for the information.

Becuase #table names max length is only 116 characters in SQL Server 2008 r2. its also valid of SQL SERVER 2012.

Nice question. Thanks for sharing

Nice question. Thanks for sharing

Nice and easy. Thanks for sharing

There are many possible ways to generate CSV file.

1) Use BCP command line tool to generate CSV

2) Use SQL SERVER Import/Export wizard to generate SSIS Package and use that.

3) Use...

can you elaborate this in detail?

how you are generating your file is the cause not the query if its giving you the proper result.

check if you are able to pass all the columns which you...

have u tried IP ?

you need to check this server 'DestinationSCODatabase'. try to login into the sql server...

check your source Login credentials, as its unable to login to sql server. try to connect to the user login and password which are configured for this SSIS Package.

Nice and easy. Good start of the week.

Thanks for sharing

did you check the indexes ?

NoDBA (8/15/2014)

---

Thanks twin devil for taking a look at the plan. Where can I find that information looking at the plan with SSMS? Or is there any other tool to...