I added some more flexibility to the script. I do not know if you want to process all files in a directory but this will process all files that...

I posted a TSQL solution at the other link.

http://www.sqlservercentral.com/Forums/Topic464002-338-1.aspx?Update=1

You may need to delete items from the @Directory table to make sure you only process the files you want. You can do a simple delete after the directory...

You can do something like this, using openrowset.

DECLARE @Path VARCHAR(25),

@FormatFilePath VARCHAR(25)

@i int,

@file varchar(25),

@FilePath varchar(25),

@sql NVARCHAR(500)

SET @i = 1

SET @Path = 'C:\Test'

SET @FormatFilePath = 'c:\Test\testfmt.xml'

--===== Create a directory table

DECLARE @Directory...

I dont think you can use cast in SSIS packages. You should use the WSTR datatype. Like this:

SUBSTRING((DT_WSTR,10)[RECD09], 1,5)

Note: I set it at 10 to prevent an...

Jeff good solution. 🙂

We need to expand on this a little further to meet requirments.

You would need to supply data for the SourceFile column, which does not exist in the...

Do any of your maintenance plans have a cleanup task? This is what removes outdated backups from the file system.

Double post.

My answer is here.

http://www.sqlservercentral.com/Forums/Topic464002-338-1.aspx?Update=1

Follow the link I posted. All you have to do additionally is use a derived column to create the filename. Like I said before you will have to...

You can either do this via TSQL or SSIS. In SSIS, you need to create for each container. In the container you will set a variable to the...

You can also just back it up to a UNC.

BACKUP DATABASE [Test] TO DISK = N'\\MyPath\Test.bak' WITH NOFORMAT, NOINIT, NAME = N'Test-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, ...

better link:

http://msdn2.microsoft.com/en-us/library/ms190389.aspx

Do you use windows authentication? If so, all of your developers should be in a group. You could disable the login for that group.

Personally, I...

Click on the source connections via the connection manager. Then look over at the properties at retain same connection. By default this is false.

Yes it is.

Maybe I am missing something here but this sounds like...