In dataflows, We are coping data from As400 to SQL sever. We have only Oledb Source and Oledb Destination. One guy who is in the other team has similar issue,...

Thanks for the help Vikas & Srikanth,

Here are the answers for the above queries

1. Are you executing on the same server in both the scenarios?

Yes, i have deployed the package...

Can anyone help me to resolve this issue pls?

Thanks a lot. I have resolved that issue as per your suggestion.

I need another help. I have prepared ssis package for downloading data from AS400 to sql server. I...

Thanks for the reply. We can do this if both source and destination are on the same server. I am using AS400 as source and sql as destination. How do...

Hi,

Can someone reply to this post? Is it possible to do this?

Surya

i think i missed the connection string for as400

Driver={Client Access ODBC Driver (32-bit)};System=AS400DEV;Uid=myUserID;Pwd=myPassword;

I am getting the below error while executing my package from SQL Server 2005. Actually i am importing data from AS400 to SQL. Do i need to configure anything in...

Hi,

I am getting another error while executing SSIS Package in SQL Server.

Declare @cmd varchar(1000)

set @cmd = 'dtexec.exe /f "E:\SSISPackages\SSISDeploy\ExportData.dtsx" /Set \Package.Variables[SourceDB].Value;AS400DEV /Set \Package.Variables[DestinationDB].Value;SQLDEV /CONF "C:\SSISDeploy\Environment.dtsConfig"'...

Thanks a lot. It helped me a lot. I am accessing SQLMain variable inside Script task and updating connection string value of connection manager.

How do we use same...

Thanks a lot for the immediate response. I am not sure how to implement this logic. I am new to SSIS Packages. Please see my code below and correct me

1....