yes. float

I ended up writing this code:

(DT_DATE)((DT_STR,30,1252)TradeDate + " " + (DT_STR,30,1252)MessageTime)

That's pretty cool. I'll try that out in SSIS. Thanks

Sorry about that.

For the date field the data type is date and the time field the data type is time. The destination has the field as datetime. So...

I ended up using Alvin's recommendation and write c# code in the script task.

I was thinking that as a backup. I haven't worked with the foreach loop container so wanted to give that a try. Thanks Alvin!

I'm following this article: http://consultingblogs.emc.com/jamiethomson/archive/2008/04/17/ssis-deleting-a-group-of-files.aspx....

Ok. That's what I was thinking. I'll use a Script Component to get the max date. And then use the for each container and file task to loop thru...

I need to delete files that are older than 5 business days. Can I do it using a foreach container and a file system task or do I need...

I was able to get this working by doing a data conversion prior to the oledb destination. And then storing the data conversion column in the table. I...

You were right. The datasets were referred incorrectly.

In the merge join transformation, when I do an inner join I only get 1 record back. However, when I do...

From what I know, SSIS doesn't have an inherit way to do that.

When I had to create a nested XML file I did that in the stored proc and then...

The format of the variable being passed was incorrect. The variables were set correctly with evaluate to expression. Sorry for extending this post. It was a...

Unfortunately, it is complex. And I think it's more of me not setting up the fst correctly. Do I need to set the source and destination properties...

Yes, it is.

I'm using the DtsRunTime.package to call the package and package.Execute to run the package. In the same library, I'm using DtsRunTime.Variable to pass the variables to the package.

Does...