Hi Shaun

Please check out the following link:

http://www.mssqltips.com/sqlservertip/2061/how-to-manage-ssis-packages-stored-in-multiple-sql-server-database-instances/

Br.

Mike

Hi LadyReader

Did you try

command.CommandType = CommandType.StoredProcedure;

instead of

sqlCommand.CommandType = CommandType.Text;

Br.

Mike

Hi

This property provides the ability to bypass the prepare command for OLE DB connections, because prepare does not support some Transact-SQL keywords, if you are using a parameterized query...

Hi

I'm guessing that your native SQL connections are 'trusted'

,so please set Protection Level for this package to "DontSaveSensitive" and try again run in 32-bit mode:

<drive>:\ Program Files(x86)\Microsoft SQL Server\110\DTS\Binn\DTExec.exe...

Hi Daniel

Please open cmd and type command: set USERDOMAIN on both machnies and comapre the results.

If they are the same, your machines exist in one domain, else in different.

Br.

Mike

Hi

It looks you have 32-bit odbc drivers , try to run your package from cmd using :

<drive>:\ Program Files(x86)\Microsoft SQL Server\110\DTS\Binn\DTExec.exe /F <your package>

and let us know the status.

Br.

Mike

Hi

Did you configure new DSN from C:\Windows\System32\odbcad32.exe or C:\Windows\SysWow64\odbcad32.exe?

And could you please answer Koen's question.

Regards

Mike

Hi

I'm not sure what you are looking for, but try this:

SELECT t1.Col1,t2.Col2

FROM ...

Hi Koen

I've already met with that problem. Package tested on wkst with 32bit odbc and moved to 64bit environment, of course there were installed 32-bit odbc on the server. ...

Hi

I also don't see alias "p".

Br.

Mike

Hi

Did you set Run64BitRuntime as false?

Br.

Mike

Hi Daniel

Please check permissions for user: (Database Name)\SYSTEM for shared folder.

Owner of the Job should have write access to that directory.

Br.

Mike

Hi Aadhar

I'm not quite sure what you want to get because I see the gap in string result between "ND" and "Nokia".

But you can separate words and numbers as shown...

Hi Djmarkoos

Imho you can try in such way

--Temp table for test

SELECT 'OK' AS statuscd, 22112233 AS ordernum, 'john' AS name,'17/09/2013' AS dateord, 'john@john.com' AS email, 'N' AS sentid

INTO #dbm;

INSERT INTO...

Hi

Temporary tables are limited to the session. A local temporary table that is created in a stored procedure is dropped when the procedure ends. You execute proc test2 when...