Yes thats what I want to do, but how to I make One SSIS Package call another?

Thanks very much for the detailed guide!!!

Error

Error: 0xC001F009 at Package4: The type of the value being

assigned to variable "User::Date" differs from the current variable type. Variables may not change...

Thanks,

I am a bit new to SSIS but I have managed to do:

- create a variable

- create an 'Execute SQL Task' that will contain the query below

SELECT message...

thanks for your time, I seem to be getting an error on the SCRIPT:

Error 30456: 'IntDataTypeDate_isNull' is not a member of the ScriptComponent_035fc3ff0ed01a2264ac......

What im doing in the SSIS:

Run_Date(INT) --DataConversion--> Run_Date(DT_STR) --DataConversion--> Run_Date(DT_Date) --INSERT INTO TABLE--> FAILS

Error:

It fails on the last DataConversion, with the error:

Error: 0xC02020C5 at Dealbook Job History, Data Conversion 1...

What do you mean?

The SOURCES table stores the run_date as INT

In the destination table...

Thansk, you guys have been very helpful.

the problem is, the source table sysjobhsitory has the run_date set as INT.

In my SSIS I converted it to a string first, then into...

Right slightly lost now.....

Does this mean I have to go back to the source change the import type from INT to Date?

The Source data is coming from the system database...

Hi Lynn,

Its as the in of the SP:

Thanks, what does the following line do?

JOIN (SELECT job_id, MAX(curr_date) curr_date

Thanks buddy, very helpful!!

Would this be a SP?

As I said, the jobs & job_hist tables will be populated by my SSIS so im just intested in exporting the data from...

Thanks Flo,

Can you brake that code down so I can understand it?

I can see your doing an insert in Jobs an Job_hist, this insert is already being odown via my...

To recap:

This is what I want:

Source Table

Date Column - 20090308 (int)

Convert to:

Destination Table

Date Column - 2009-03-08 (Date)

I have set up a Data flow which:

1. picks the data up from...

Thanks but i know nothing about Microsoft Visual Basic .NET

Im getting the following error:

Incorrect syntax near ' ' -