Hi,

I jst followed the link wh u hav specified there,

but one thing is like how to create a batch file for all the packages, can i get any syntax for...

Mike,

I am having so many packages in my system like sales_report.dtsx, purchase_report.dtsx... like that

i am having nearly 20 packages. some of them are in server side i.e msdb level.

some...

Hi all,

Can any body tell

What is the main differences between File System deployment and SQL Server deployment

needs all major advantages and disadvantages...

Thanks,

pcsb

Hi all,

Can any body tell

What is the main differences between File System deployment and SQL Server deployment

needs all major advantages and disadvantages...

Thanks,

pcsb

Hi all,

Can any body tell

What is the main differences between File System deployment and SQL Server deployment

needs all major advantages and disadvantages...

Thanks,

pcsb

Hi all,

Can any body tell

What is the main differences between File System deployment and SQL Server deployment

needs all major advantages and disadvantages...

Thanks,

pcsb

can any body solve this issue....

U r right, but it is working...

upto creating the table it is working but while to import data from sp_columns it is not working and showing error like

Msg...

Thanks to all...

ya u r right,

wt my question is..

my table name is 'claims',it is in 'adventureworksdw' database..

by mistake i have renamed that 'claims' to 'sp_columns'

now the table name is 'sp_columns'

so now...

ya u r right,

wt my question is..

my table name is 'claims',it is in 'adventureworksdw' database..

by mistake i have renamed that 'claims' to 'sp_columns'

now the table name is 'sp_columns'

so now...

old table name: claims

new table name: sp_columns

database: adventureworksdw

command: sp_rename 'sp_columns', 'claims'