Thanks

I have got that part.

I am trying to get the file name out of the Array, and assign the value to a variable.

How can I do that using C# in...

Using a Script Task in SSIS, what is the best way to gather a list of file names? There will be an unknown number, but certainly less than 5.

Or can...

Yes, I can use a table, but I need to store each one in an array, or something until the step to insert the list into a table.

Andrew SQLDBA

Thanks Everyone

I had to take a little from each query to get what I needed, in a timely manner. I had over 500 million rows to update. But it was...

Yes, I remember those days, things were more simple then.

The table was dropped, but a couple constraints were not dropped. But I did find out that the code that created...

I have tried that, I was looking for something to simply be used to update a couple columns, but keep the original.

Thanks

Andrew SQLDBA

Yes, I have experience with Log shipping, Mirroring, and others.

It really kind of depends on how many transactions per second, minute, hour, day, week that database is going to perform.

It...

That is why I suggested that you take only a Differential backup. That will stay some what smaller for a long time.

How many transactions per second are you receiving on...

What I would consider, is after taking a full backup at anytime, and restoring that to the other box. Then, I would create a Differential backup on an everyday schedule...

That is exactly what happened.

I don't waste too much time Searching, I know the real SQL minds are here, so I post, and I usually get faster response

Thanks again

Andrew SQLDBA

Thank You

I was doing just that probably as you were typing your suggestion. Which works perfectly by the way.

Sometime, I either find an example, or I try something else, right...

Update to Original post

I just saw some of the data as only 3 digits. So 499 would need to be converted to 499.00 etc.....

There may also be a single...

Yes, thank you

That worked perfectly

Thanks again for your assistance

Andrew SQLDBA

Thanks Gila

I was not sure about the 2 versions of 2008.

Greatly appreciate your answer and comment.

Andrew SQL DBA

It does not matter where you let the SQL executable reside.

I never, ever use Drive C for anything. Not even the OS. I install all other instances on the same...