Hi All,

Apologies if my post was rude or if it did not adhere to the standards on the forums. I had no intentions of being rude, I was just not...

Hi Andreas

This was just what I required. Thank you very much

Regards

Hussain

anyone?

hmm would try what you have suggested and see the performance

have you ever tried to start the job on the server with sp_start_job. you can connect to the database server and run this procedure

i guess this store procedure should work...

could you explain further what you exactly requires.

from what i understand you want to add an extra column while loading excel data.

as in if excel has column A,B u want...

braghuram

thanks. i was able to delete the packages from the msdb.dbo.sysssispackages tables.

rene

As i have said, i do not have access to admin tools on the sql server or on my...

thanks both

will check and get back

Rene

thanks for the reply.

However, i do not have access to Administrative tools on the server.

I connect from a client system to the SQL server that is install on an external...

U can use conditional split to split the data into two seperate destinations based on a conditions.

get the data from the file into a temporary table.

use a select query like

Select...

I always use the rownumber - partition query to remove duplicates .

Get all the data to a temporary table. use the row-number partition query and conditional split to seperate original...

anyone?

If you do not wish to archive the files, you can use a log table or a log file to store the name of the files already imported. Use a...

Hi

The run as is a drop down and as i see only the Sql agent ID appears in it :crying:

is there any other place where i can set my ID?...

i have a very similar problem.

I have to schedule a package in server A. The package uses data from server B. I have access to server B . hence i...