Table A has a primarykey called has a primarykey called TblAPrimeKey

Table B has a primarykey called TblBPrimeKey as well as a foreign key from table A called TblAPrimeKey.

There are several...

unfortunately not. There is no column that I could use that way. I noticed that I didn't remove the index on the destination table, hopefully removing the index will make...

I figured it out. Apparently you can create a raw file by selecting the top 0 * from a table if there is a timestamp datatype column in the table....

I looked at the properties and I am actually using Std Ed. On that server. Doh!

That worked until my dynamic string became larger than 8000 characters. IS there any way to do it without the dynamic statement being created on the fly? I'm thinking the...

My CaseID is actually a uniqueidentifier type. How can I update it to work with that? I tried to change the declaration to uniqueidentifier but it gives me the...

It doesn't help. In that example they know ahead of time how many values there will be and it uses the sum aggregate. I can't use any aggregates. I'm basically...

Never ming the above question. They were actually wanting to calculate a percentile of the values so if someone could advise on how to go about calculating a percentile?

Will give it a try...Thanks

I think I found a way to get the job done without taking so much time using a merge join. I added anothe data flow where I load the contents...

I was actually able to complete the process of 110 million records in 17 minutes

I'm actually getting the data in a flat file and then I run a package that converts it into one common schema we use and is placed in a raw...

Vishal, you're the man!

I stopped my process (was scared to death since in 20 hours it had loaded 60 million rows) and changed my max commit size and the Rows...

yes

Raw file created by SSIS Raw File Destination object