Nithi

Please will you be more specific about what sort of help you're looking for? A good place to start would be if you posted your stored procedure definition.

John

Wardy

In that case, put all your file names in a table and use a For Each Loop task to loop through them.

John

Wardy

If you only have ten categories then it's probably worth setting up ten separate file connections and ten separate dataflow tasks. If you don't want to do that, then...

Vamsy

Since the operations you mention are fully logged, I would say that doing one of them on the source database would also do it on the target. That's just...

Kevin

This sort of string manipulation is best performed by your application rather than SQL Server. If you really need to do it, you should be able to use the...

The fact that the device type is a virtual device suggests that your database is being backed up with a third-party utility such as DPM or NetBackup. If your...

If you don't already have this property set up as part of a package configuration, or taking its value from a variable, then I don't think you can do what...

Jerry

As Steve said, you don't need to assign any permissions. As long as you specify the account as the service account during installation or using SQL Server Configuration Manager,...

A warning message? I don't think SSIS is designed to do that: it runs as a service and doesn't depend on anybody being logged on interactively. If you...

David

I think you can get that message when you have ant-virus software trying to access your database file. If you do have anti-virus software installed, please check that it...

David

Databases in Simple recovery mode do have a log file, but you can't back it up since it is automatically truncated by SQL Server on a regular basis. Therefore...

Try building in a small delay between iterations - two or three seconds, maybe. This may allow time for the transaction log to clear before the next iteration. ...

SSIS (Integration Services) and bcp are designed for this very purpose. You should use one of those.

John

OK, here's what I've just tried (Windows XP SP2, SQL Server 2008 SP1 CU4).

- In Computer Properties, add a system environment variable called Test, value Test

- xp_cmdshell 'set' Result...

I've thought about this a little more and I think what is required is a restart of SQL Server, not the whole computer. This is because the service account...