Hi could you (or someone else) please explain how to do that. Let's say I want to hidea specific property in one of my SSIS package components, for example a...

Thanks for the answers....

I think I might have found the solution for the vbscript part...but still one big thing remains..to be able to call up BCP utility command for bulk...

Thanks for the reply..and sorry about the cross post...

Could you tell me a littel bit more in detail how I can set up thsi parallell execution (for example through SQL...

Hi and thanks for the answers..

how can I use the "for XML output" to have the xml generated to be saved to a a fixed file ? Can I in...

Hi,

Yes, its an already exisitng and working (SQL 2000 DTS) VB script..so therefor i wanted to use it.......running out on time. Anyway, I found a workaround (good or bad ?)...i...

Hi and thanks for the answers...

The FOr Each loop is the available "For each Loop" component available from the SISS toolbar........

What about IF I want to have all files not...

Hi

Thanks for the answer......what I dont understand is how I can get the "CP1" added to the collation..if I go properties for my sql server installation it reads SQL_LAtin1_CI_AI

I have...

Hi

I'm running SQL server 2000 standard edition

Hi again,

This is my main query against the mainItem table

SELECT   Select [mainItem.ItemNumber]                                                                                        AS [Main_Id_ConstraintGenerated]

FROM     [mainItem] [Main] 

WHERE    [mainItem].[Active] = 'Y'

ORDER BY [Main].[ItemNumber] ASC

......let's pretend that this query returns

the following items...