GSquared thanks for running the numbers. I know that the XML is the fastet method I have seen, but I had never gotten around to running the numbers.

Create a variable for the path and use get date functions. Click the connection manager for the output text file --> View the properites --> expand "Expressions" --> choose connection...

Create a data conversion task. Change the numeric columns to string. Then use a derived column tasks and put this in. Note this is to make a...

The above is an example of how to do it in TSQL

Are you exporting via a view or just a table?

You will have to either pad the column in SQL or using a SSIS expression.

SELECT RIGHT('0000000000' + CONVERT(VARCHAR(10),1234567),10) AS [10 LENGTH]

Correct, thanks for pointing this part out....

The convert is used to take only the first 6 characters which are 200803. Then the query appends the one on the back to make the string 20080301.

This piece of code creates the beginnning of month.

select convert(varchar(6), getdate(), 112) + '01'

Absolutely not!! :w00t:

I was commenting on your post. I should have put...

The second query is saying to take the difference, in weeks, between the beginning of the month (3/1/2008) and today's date + 1 (3/4/2008).

The + 1 at the end is...

You need to perform a transaction log backup. You should also put maintenance plans in place to ensure your recoverability and to prevent the log from growing, so large....

If you do not want to use the file system task you still have other options. These options include mirroring a copy of the file to the folder of...

Yes, it does. 😀

You can use the file system task to copy the backup to a folder of you choice.

You can also run the setup and only tick the workstation components.