Almost certainly a permission problem.

Make sure that the account that sql server agent is running under has the right permissions.

Also check your sql server settings by running dcomcnfg.exe from...

If I understand you correctly, you want to split a single column of data contaning first name, surname etc into separate columns in a database as well as one straightforward...

Yours is not an unique question. See this link:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=140736

The best thing you can do is to get the users to save their files in the same folder each time. You can then cycle through all the files in...

Why not use the filesystemobject to see if a file exists and execute your sp every few minutes. You can use the result of the filesystemobject check to exit the...

Quick and dirty fix:

If you have an incremental ID in the table, restrict the data returned in the query. Then set up tow or three dts jobs to each export a...

As far as I know you cannot.

Only hint I can give is to export data to another excel file and run a copy job overnight.

Try replacing

A"AcctPeriod:String=200401"

with

/A "AcctPeriod":"8"="200401"

Sounds like a permission problem.

Make sure that the account that sql server agent is running under has the right permissions.

Also check your sql server settings by running dcomcnfg.exe from...

It is possible to do this, but you are really re-inventing the wheel.

Have a look on the net and you will find some very cheap tools that do this.

Have a...

Apologies. Gave you a bum steer there. I have been migrating jobs over for the last few weeks and got mixed up with them.

The way to get them back in...

I often move packages across servers using visual basic.

Save the package as a visual basic file, then open it up in notepad. You can then change the connection settings within...

Glad to have helped.

The code above is using a trusted connection to connect sql server. You can specify a sql serer username and password in the connection string to achive...

I think that you are taking the wrong approach. It's not a good idea to use sql server to initialise another application in this scenario.

I would think that you want something like a...

Quick and dirty way is to loop through a distinct set of customer records and bring into a cursor which you can use in a where clause to bring back a normal top...