I think that the following line of code only works on SQL 2008

DECLARE @i INT = 10

In SQL 2005, it should be

DECLARE @i INT

SET @i = 10

Lempster,

Thank you for your help. Now I have another question regarding to my project. basically I need to generate a report and export it to the spreadsheet and then send...

Could you give me some hints how to set up dynamic email subject and message? Thanks.

I'm interested in this article, but where are all of the screenshots? Those images will help the readers to understand what you were talking about. Could you please repost the...

Check this out:

http://forums.microsoft.com/Forums/ShowPost.aspx?PostID=3491777&SiteID=1&mode=1

Deplicate your table which is used to insert data from the flat file and then execute your package to import data into your duplicated table. So you can check and...

Did you try to use Execute SQL Task (under Control Flow item) to execute your SP? It works for me.

Could you post an example to explain what you want to do?

You can use Import Data feature to insert data from csv file to a table. In the Data Source. You have to choose "Text File" from the dropdown list. If...

The way of backup/restore is a better way to create your Fresh DB. After it is created, if you would like to refresh data from your production DB to your...