Thanks Adi for your reply.

I am very new to the system. Still need to dig out what all queries are getting fired on this table. I have got around 12...

You don't have to drop the staging rather you can TRUNCATE the staging after you load in destination table is completed.

Try this one

bcp LoggingStage.dbo.MyTable out "C:\inventory.txt" -n -T -S SERVERNAME

replace SERVERNAME with the name of your server

Please don't post the queries at multiple places.

http://www.sqlservercentral.com/Forums/Topic724861-145-1.aspx

Rightly said by Eswin, there are many ways.

But i wanted to ask you one thing: if you want to move your data into BCP files and delete that data from...

The solution I would use in your scenario would be:

1. Have a staging table(with same layout as your destination table) and load everything from excel into the staging table.

2. Update...

Creating different DFTs is one way to achieve multiple table transfer. And this is the simplest one.

The other way to have a loop and do extract and load by dynamically...

Do you have a connection manager with the name "1APWN0001.test.dbname"?

Please post the config file also.

Where is the error message?

i've created the xml file, and followed the steps to configure the file, but when i execute the package from my .net application, it is not accesing the servername(src name),...

Hi,

Can you be more specific....

what do you mean by this statement:

"I need to specify that user A has the rights to create table in his own login, but not...

For using of the XML file go to Menu SSIS -> Package Configuration -> Add..

If you want to transfer multiple table you can make use of Import/Export wizard...then save the...

Or you can try something like this:

SELECT datediff(dd

,entdte

,CASE compdte

WHEN '1900-01-01 00:00:00.000'

THEN getdate()

ELSE compdte

END

)AS WORKDAYS

FROM svc00200

Thanks Mark!!

There is no need to loop on the records

You can make use of "Conditional Split" Data Transformation to achieve this. Put the condition on the value of the source table...