If I interpret your request correctly, you want to read through the file and associate all of the repX records with the most recent idX record. If that is...

You're right, I misread the OP's spec. Thanks.

Thanks for the update, let me know how it turns out.

Is the "Sequence" column the last column you have defined in your flat file connection? If so, you're short by 1 column since you have a trailing pipe at...

Can you provide more information about what you're trying to accomplish? It looks like you're trying to script in SSIS but it's unclear what your goal is.

For a simple data flow operation, you don't need to script it; you can use the OleDB Destination to write data to your SQL Server database.

hth,

Tim

Sylvia, a well written article, and I can agree with you that using random aliases such as "a", "b", "c" is counterproductive. It's difficult to read and even more...

I have a Bachelor's Degree in CS, but I should add that I'd been working in IT for over 6 years when I completed the degree. I went back...

No, I didn't find a way to make this work. As an alternative, I created physical tables rather than views, and populate them as part of my DW ETL....

Consider creating a table of dates (see this article: http://www.sqlservercentral.com/articles/Date+Manipulation/65195/) and join your Hotels table to that new dates table. The resulting join would give you a discrete list...

My recommendation is that if you're dealing with changing metadata, use your script task or script component to manage your staging tables.

There are a couple of ways to...

There is no such thing as a generic transformation. What task are to trying to accomplish?

You've specified the 1256 code page, which is the Arabic case-insensitive code page. Keep in mind that you can set the collation at the instance level, database level, table...

Yeah, I'd stay away from defining your metadata at the vendor level. Bob is right - it's a nightmare waiting to happen. Billing companies could end up with...

First, let me address the suggestion of using a SQL Variant data type: DON'T. This looks terribly convenient at first glance, but it's ripe for disaster in real-world use.

You...