I tried with SSIS using two datasources and using the same excel destination

But it resulted as

AACase CCCase

...

For October I used:

"A_"

+ RIGHT( "0" + (DT_STR, 2, 1252) MONTH(DATEADD("MM", -2, GETDATE())), 2)

+ "01_"

+ RIGHT( "0" + (DT_STR, 2, 1252) MONTH(DATEADD("MM", -2, GETDATE())), 2)

+ (DT_STR,...

Thanks. But this doesn;t work for month of October.

Destination is excel, how will we able to use ace oldb, can you please explain?

Microsoft excel 97-2003

Single quote is after exported to excel.

So how do I remove this?

Update dbo.voters

Set rec_num = DENSE_RANK() OVER( ORDER BY part_no)

from dbo.voters

Got the error for the script above.

can you re-post the corrected one? I cannot see it.

Thanks,

got this error:

Windowed functions can only appear in the SELECT or ORDER BY clauses.

It's 2005.

Thanks, please consider this one.

I am newbee on this.

What I am trying to do is set @rec_num to 0 and then

Set @Nrec_num = @Nrec_num + 1

Set @SQLexec = 'Update...

Yes let's see what see, have asked them to get the text version of the records and use then we can use BCP if not use smaller batches.

Thanks for all...

It is how the vendor sent in the script?

Other thing I can try is to ask them to load data into text file and use BCP.

Thanks Sean, but this does not give me column names.

Going back to my initial scenario. I have stored procedure created in one database but in the stored proc itself, it...

Thanks, this works on 2008 R2 but I need for 2005 and functionality

sys.sql_expression_dependencies does not exist on 2005, what do you suggest?

Thanks. But this does not help if I am the stored procedure is pulling information from tables in different database.

I am asking some automation method because there are 100's that...