+1

Any time you can get away from the csv (quoted, or not) format - and...

True, that's is why I edited my earlier response when you pointed that out, changing component to task (which is what I had originally meant - wrong term).

The solution does...

As follow up from yesterday, I've uploaded a zip file containing the dtsx package (detailed below) and a folder (containing an A and B file) that should be saved in...

Without PS or a script component task, you can treat the data records in the given file as a single column text field. In the data flow, start with...

mmartin1 (4/30/2013)

---

When you want to schedule the job, do you need to provide the package password in the agent configuration? If so would you need to restrict access to who...

Another thing to consider, too, is do you have any sort of identifier or key in the DB2 source that could allow you to effectively break your source data into...

You can also download evaluation versions (full) of SQL Server from MS ... 2012 looks like it's a 6-month eval. It's something to at least get you started without...

If, as Phil has assumed/you've implied, you are exporting data from multiple source columns and concatenating them into a single export/destination column, you still need to account for the NULL...

Another option that hasn't been mentioned is using PowerShell: you can use PS to effectively treat Excel sheets as tables and either shred them in to a delimited file for...

Try it out: if the source text file has an empty string (per the original post), the Retain NULLs option will treat that empty string as a NULL and not...

Also, you should see an option bit in file source connection in the data flow to retain NULLs ... this will retain the NULL "value" from your file and not...

Are you trying to just get the calculated values imported into a table, or are you trying the actual formulas imported into a table? If you're just trying to...

As a few of the above replies, I'm not familiar with working on AS400, but here's a thought on how SSIS might be handling the empty/NULL date that you're mapping...

If you're asking that when you update/change a variable's value in BIDS, will the associated xml config file be similarly updated, then no. If you update the variable within...

One other thought: if you have the same number of base fields that you need to work off of every day (say, the first four columns), and everything after those...