I thought it might work but it didn't. Going back to the initial table we created, the result set is this.

grpledgers

1A01,A01

1A02,A02

1A03,A03

2A22,A22

3A33,A33

3A36,A36

Thank you for your time. All your tips...

Thank you so much!! I will start looking at creating a loop to concatenate the ledgers and see how much time it adds to my process time. I...

Thank you so much for taking the time to look into this.

--Here is the temp table to load with transactions from ledgers.

--Ledgers are phisical tables. There are 122 ledger...

Jeff,

Your suggestion with the function almost worked except that I have to work with a temporary table and so I can't use the function.

I have been trying to avoid the...

Thank you so much for that article and all the performance tips. I'll give that a try.

Thank you so much, this works perfectly!!

I support 3 environments, sql 2000, sql2005 and sql 2008.

This report will reside in our sql 2000 server for about 6 months and then...

Turning on the Unicode setting in my Destination File solved the problem.

Thank you!

In the Code Page, I see Japanese, Chinese..... My file can contain any of these. The default is set to 1252 (ANSI - Latin I)

That is not checked but how do I know if the code page I am using support the characterset I am using ? I'm not sure what this means.

How do I check that?

Thanks for the explanation. I've tried different things and here's my last attempt with NO success.

Also I am doing a Multcast. Would the Multicast have an issue?

Description nvarchar(200)...

This is very helpful. Thank you!!

One more question, how do I spit out the servername and userid (if possible of who is executing the pkg.) to my log.

I have created SQL Serverer package configuration and...

Thank you both so much. That was exactly correct. The event handler worked great. With this, however, it looks like for each and every task, I will...

I don't know how to put the e-mail notifiction into the OnError event handler.