Jim, I created a cmd file calling the package....but where can i call this cmd file? i am not getting about the task scheduler..Could you please tell me?

jim.david (7/20/2012)

---

Charmer

The contents of the cmd file are fairly simple

dtexec /sql "Dataload" >i:\xx\xxx\dataload\logfiles\dataload.log

call e:\\dba\common\BATCHscripts\datestamp_file i:\xx\xxx\dataload\logfiles\dataload.log

The package Dataload is run from the server dataload.log is to capture the output from...

jim.david (7/20/2012)

---

I had the same problem with packages that use an ADO.NET connection to an Ingres server. The connection login for Ingres is different to my local SQL server...

ok Koen, Let...

This is the command line after modified...

/FILE "D:\Backup\Projects Backup\Partitions_19072012\Partitions\bin\AS.dtsx" /CONNECTION "ADONET connection for DW database";"\"Data Source=MySource;User ID=sa;pwd=Pn***;Initial Catalog=DW;Persist Security Info=True;Application Name=SSIS-Package-{859CFD36-7337-487A-8994-9F103BBCEE4A}MySource.DW7.sa1;\"" /CONNECTION "AS Database connection";"\"Data Source=MySource;Initial Catalog=DB;Provider=MSOLAP.4;Integrated Security=SSPI;Impersonation...

Koen Verbeeck (7/19/2012)

---

At first sight, it looks OK.

(except that the passwords are missing, but I think SQL Agent leaves them out for security reasons).

The connection name still uses ".NET" though....

richykong (7/19/2012)

---

Do you use any variables to update the data source? You might want to check if you've set the data source to update it's connection string/database information to...

Sorry Kraig, let me make you clear...

i created this package on my local and executed successfully...

the same thing i was trying to do on the production server, what i did...

Evil Kraig F (7/19/2012)

---

Did you use a job to run it or did you manually hook to the production databases to try to run it?

If it's you, you probably don't...

Thank you Lowell, Lynn...

I forgot the 121....

/FILE "C:\Users\administrator\Desktop\DB...

yes, Koen..i did modify the connections tab with proper crendentials ....that...

not worked , Koen. Still getting the ADO.NET connection error.

ok Koen, Let me try

Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted

07/19/2012 14:55:51,DW,Error,0,MyPC,DW,(Job outcome),,The job failed. The Job was invoked by User...