Setup your file source to skip the first row and don't use the header info. As long as each file has the same format there should not be any problem.

Hi, We're also using SVN and wan't to know if there is any possibility that the merge function would work for a dtsx file modified by 2 developers. I can't...

I just re-read your post and you say "Access mode to Fast Load" I assumed you were referring to an OLE Destination, is that correct or is Access mode something...

I run fast load on all my inserts. Unfortunately we've been trying to get the latest release deployed and I have not had any time to investigate. We are in...

Shawn how are you doing the update in the dataflow task?

I am taking a similar approach but using a merge join instead of a lookup.

I am using an OLE command...

Sorry about the generic question, I am always hoping for that big thing that I missed that's very obvious. I will take you suggestion with the logging and compare prod...

Here's another take on the staging database. In order to process the data of the transaction system and prepare it for the DW structure I have many stored procedures and...

Not exactly sure what your asking but here's what I have for my CM's.

Using SQL configs to set the connection string property. Config database is located on the server running...

Thanks Lynn,

that is what I figured but wanted some verification.

thanks tim,

Thought about doing that but since the hotel contracts sometimes expire but we keep using them so we defaulted the contract end dates to the end of time and...

when you say runs in sql I am assuming you are running via the agent. In which case it's probably an issue of the agent security level with the file...

I need a checksum for my sharepoint list datasource, otherwise I would use the checksum TSQL function.

Thanks for the info though.

I think what happened was the new query had the same column name in the same position as it did in the previous query so it did retain the same...

yes it does, but it does not do set based updates. It's row by row. Which makes it very slow.

I do use it for most of my dimensions because...

Hey GSquared, thanks for that post. - Haven't moved to '08 yet.