Regarding the warning about "Cannot retrieve the column code page from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be...

This is a question about Agent, not SSIS. http://www.sqlservercentral.com/forums/messages.aspx?forumid=110

-Jamie

SQL Server memory constraints do not affect package execution. SSIS is subject to its own memory limitations: http://blogs.conchango.com/jamiethomson/archive/2005/05/29/1486.aspx

I don't know what you mean by "execute SSIS workflows as an outside...

1. Use a multicast to split into 2 data paths

2. In first data path, use a SORT to get the distinct list of currencies. Push that data into CurrencyMaster

3. Push...

The SSIS service is not used in BIDS so the fact that everything works fine in BIDS is irrelevant.

The SSIS service is not instance aware. So, just enter the name...

Hi,

This should answer your question: http://blogs.conchango.com/jamiethomson/archive/2005/04/20/1324.aspx

-Jamie

You can loop over the contents of a recordset using a ForEach loop.: http://blogs.conchango.com/jamiethomson/archive/2005/07/04/1748.aspx In your case the recordset will be te list of ReportIDs from the header table

You can...

The error isn't showing!!

-Jamie

What error did you get when trying the SSIS approach? Once the data gets into the pipeline the version of the source system is irrelevant so this can't be the...

Correct. SSIS does not support storing a package as a VB file.

-Jamie

FYI

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=377979&SiteID=1

-Jamie

Synchronous components use the same buffer for input as for output. Therefore, any reference to input columns is also referencing output columns.

Any new columns that you add to the script...

Carol,

Absolutely not. SSIS process data in the pipeline wthin memory buffers. The size of each buffer is determined at runtime and as many buffers as are required are created in...

Use the DelayValidation property to...well...delay validation.

If this property is set to false then the container it is scoped to will be evaluated when the package starts up and when the...

I answered your post on the SSIS forum: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=355435&SiteID=1

-Jamie