The report is merely displaying the data from the stored procedure. It does have some company logos.

I could run the profiler, but I was wondering if someone could interpret the...

I tried the cte version too and got this error:

Incorrect syntax near the keyword 'INTo'

I had posted this on another forum - lazydba and was told that you could not...

I tried that and still got the same error.

Definitley simpler, will keep that in mind

Thanks much

KR

1000mb is the final subset. The time that I am talking about is for the tool to migrate C_ISAM system to a staging sql database, do data cleanup, tranformations,...

I am still evaluating , but it is estimated to be around 1000 MB.

KR

The main issue is that the 'datawarehouse' has not been really designed well. It is in its infancy and still undergoing data discovery. We are working on it...

We do have a staging database. It is after all the transformation and cleanup the data is moved to the data warehouse. We are creating this new...

I will look into that, but I do need a correct count of the files that the for each loop has processed - based on which certain notification needs to...

I am not sure what you mean by display the package,  are you asking me to send you a copy of the whole dtsx file?

By the way,  I wanted to...

Since noone seemed to have any pointers,  I created a script task that checks for the existence of files before the For Each loop container and fails the package if...

Found my solution:

Here is the code I replaced to get the date in the format that I wanted, in case anyone is interested:

(DT_WSTR,4)YEAR(GETDATE()) + RIGHT("00" + (DT_WSTR,2)MONTH(getdate()),2) + RIGHT("00" +...

hmmm,  however SSIS seems to.

Thanks

KR

Identical as far as the sql server set and permission go - and the network people say identical as far as the operating systems go.   Of course I realize that...

Found the cause !

BCP will not export more than 1026 columns -  I verified this through a couple of tests.  Unfortunatley,  I did not find this documented.  Anyway, I hope this...