[p]I learnt new thing today. Thanks Ronmoses.[/p]

[p]I accept. And you can use Script Task instead...

[p]May this link is useful for you: Table Variable :Doesn't care[/url][/p]

That's true.

[p]In BIDS, right click on your package -> click on View Code -> and search for your configuration file name or configuration name. Modify file name there if anything is...

[p]I have attached a screen shot of Target Connection manager. Kindly check that let me know if any other information is required. [/p]

[p]How diffpckcfg.dtsconfig file been created? Did you create this configuration file along with pckcfg.dtsconfig? May be it is helpful when you view code of your package.[/p]

[p]Good point, covered nicely. I like it.:smooooth:[/p]

As I mentioned above, that's almost certainly because your master database is in compatibility level 80 (SQL 2000), while your other databases are in compatibility level 90 or 100 (SQL...

[p]This query returns count as 20 when executing against "master" DB (excluding '\' ASCII character number 92) and returns 21 when executing with other databases.[/p]

[p]Thanks yaar.. good question..

To disable..

[/p]

DISABLE TRIGGER Person.uAddress ON Person.Address;

GO

[p]And to Enable triggers, we can use this query.. [/p]

ENABLE Trigger Person.uAddress ON Person.Address;

GO

[p]It is very difficult to understand... and not able to get logic behind this query.. :alien:[/p]

[p]Hhhhh.. finally got it.

Thank you Mr. Elliott for your suggestion, it worked.

solution for this problem is: D:\temp\[/p]

[p]Yes.. it is tricky, this query also results the same..[/p]PRINT LEN(@StringArray) + '-' + LEN(@Delimiter)

[p]Good question.. Also the tempdb system database is a global resource that is available to all users connected to the instance of SQL Server[/p]