You can use a Lookup Transformation to look up the values in the SQL Server table, matching the City column from the incoming data from the Oracle database to the...

Al, I suspect the error lies in the ODBC library you're using to access the data. In a recent project I was retrieving data from an old system and...

Mike, this was a good article, quite well written and thought out. It's good to think of things differently in this manner, which helps to deliver the sense of...

So here I was reading this story, thinking to myself, "Yeah, it sounds bad, but TJay's not normally a whiner so he must be at the end of his rope"....

In case it's not clear, when I refer to UNION ALL above, I mean the Union All transformation in SSIS, not the UNION ALL T-SQL statement.

The Script Component supports multiple outputs, but unfortunately does not allow for multiple inputs.

What I've done with this in the past is to do a UNION ALL to merge all...

Jason,

You'll most likely need to do this with a Script Task. You can check for the existence of a file using the System.IO namespace, and rename the file using...

What have you tried so far?

Hi Cheri,

I ran this through on my test machine (SQL 2005 SP2 - 9.00.3042), and it seems to work as intended. I replaced your data source with a Konesans...

San Antonio and Austin are both great. In fact, we did our Christmas vacation on the Riverwalk this year. My wife has some relatives in Lubbock, and we...

Sounds like you've isolated the issue, maybe a network issue, or perhaps a missing or corrupt update. If you don't mind, add another post when you track down the...

Yes, you can use Report Builder 2.0 against a SQL Server 2005 database. One item of note, I haven't tried publishing from Report Builder 2.0 to SSRS 2005 so...

Cheri,

I'll take a look. Can you confirm that you are using only SSIS 2005? Do any of your machines run the 2008 version?

Tim

Are you able to post your package (dtsx) file here? I'll be glad to take a look.

FWIW, I've never seen this approach in an SSIS package, specifically the interaction...

Cheryl,

Could you try another initial directory and see if it works there? Try hard coding to a specific directory as a test.

I mention this because Vista doesn't...