Try this:

(year(yourDatetime) * 10000)+

(month(yourDatetime) * 100)+

Day(yourDatetime)

see http://www.bidn.com/blogs/MikeDavis/ssis/236/convert-date-to-string-or-integer-in-ssis-expressions

I do not think that you can use the SSIS type conversion functions or the Data Conversion component to convert these 2 types. If you are storing a datetime...

Are all of these flat files and tables identical? Because the Data Flow contains meta data about the external sources and destinations. You cannot loop through files and...

You can add a Script Component in your Data Flow to standardize your date format. Select a "Transformation" type. Select all of the input fields. Make the...

You have to write the file back to disk. Add this:

System.IO.File.WriteAllText(fn, t)

I think the Unix format just uses an <LF> as a row terminator instead of the Windows <CRLF>. You should be able to select <LF> as your row terminator...

I think the package configuration data can only be saved at design-time. I do not think there is an SSIS runtime method that will update the config file based upon...

Do you want to update the config file prior to running the package, or do you want to compute the filename in the package and then save it back to...

It looks like your job is running in the context of the SQL Agent service logon which, in your case, is the local system account. This account would...

This is something I just learned the other day in another post but haven't had a reason to use yet. You can use .NET Impersonation. It gives you...

A little progress...now the other system is recognizing the correct login account, but apparently this account does not have the necessary permissions to log on to that system. I...

Elliott W (6/11/2010)

---

I think I would seriously consider using the script task and use impersonation to handle this.. I generally try to prevent depending on other things in the file...

The temp table should work with either type. A #table is visible only to the connection that created it. A ##table is available to all connections as long...

I don't know if this registry hack works with SSIS or not - I haven't tried it:

http://searchwinit.techtarget.com/tip/0,289483,sid1_gci1059475,00.html

Maybe the File System Task is not the way to go. You might be better off writing a small BAT file. Use the NET USE command to map...