Angela,

You are correct - the file will be created even if there are no rows in your output, and there's no way within the data flow to prevent this.

A cleaner...

Do I understand you correctly that you're trying to use the OleDB Command object to do formatting on your data? If so, there is an easier way. Check...

Great, thanks for following up.

How about the destinations?

I'm not that familiar with BizTalk, but SSIS does support the use of custom code and/or components. You can build a custom data flow component using VB.NET or C#...

Is there any reason why you need SSIS for this task? If both of the objects are on the same server, you should be able to just run your...

I agree that generally the LEFT JOIN is the better performing option. You'll want to consider using the SSIS lookup in cases where you want to do some alternative...

In your control flow, are you running the data flow tasks simultaneously or sequentially? If they're all running at the same time, you may have an issue of resource...

Completely agree! Good quote.

Thanks for the...

Vishnu, the critical thing is to get the command prompt options working properly before you wrap it into SSIS. You'll have to check your PGP software's documentation to find...

Just curious, why are you casting your input to a decimal and then to VARCHAR?

If you're trying to convert a numerical data type to a SSN or tax ID, try...

mishaluba, you're right - if you're doing a lot of transformation, storage will be a key consideration. I worked recently with a very large ETL process in which tens...

Trying to do a delete/insert operation in a specific order should be done either with 2 different data flows, or a data flow and an Execute SQL Task. Can...

The DT_DBTIME data type represents a time (hour, minute, second) and not a date. Comparing a mm/dd/yyyy value to a DT_DBTIME will almost always result in an error.

Take a...