It turned out to be an access violation issue inside the batch file: The login user's password had expired. Problem fixed.

I inherited this SSIS solution from someone who's no longer w/the company, so I can't get into that right now. What I really need to figure out is what the...

Hello all,

I'm having a similar issue but the exit code is "12" while the expected was "0". I'm completely stuck and not sure what it means or where it's...

Here's what I've done so far and it works:

- Added sql task which execs stored proc which refreshes sql table with new customer #'s.

- Created a variable "CustomerList" data type...

I apologize but I forgot to mention in my reply that the Teradata connection does not communicate with SQL tables, so if I join the staging table w/the customer id's...

I'll explain the steps.

SQL task truncates sales table in SQL db.

Data flow:

ADO.NET source connects to TERADATA source with Data access mode: SQL command.

SQL command queries several views from TERADATA source...

Thank you both. I'll work to implement one of these suggestions.

Yup, that was it. It runs successfully.

Thanks a lot!

John

Thanks for the link, Luis. That worked.

J.

Correct, Luis.

I wanted to see how many records were inserted.

You're right, although, I was hoping for an alternative w/o creating another column. Unfortunately, the data type for the field is varchar(10) and the values are 'mm/yyyy' on the...

I just tried your suggestion as:

update table

set MoYear = convert(datetime, stuff(MoYear,3,0,'/01'), 101)

When I select the table the values are displaying as Dec 1 2012...

Thank you both. I was thinking dynamic SQL and that's the direction I'll go with.

Regards,

John

Done, but I obviously had to modify the expression but it works. Now, I need to send an email upon successful FTP task with the record count from the...

quick update:

At this point I just need to append a date time stamp to the name of the file (i.e. FileName_YYYYMMdd_HHmmss.txt)

How can I accomplish this?

Regards,

John