Just a quick one, Did you remember to add the fixed server role db_ssisadmin to your package reader role during deployment?

You can create the linked server using your existing code.

To configure the Execute SQL Task Editor, select your connectionType, create a Connection and test the connection to ensure that it...

I'll suggest you try editing the configuration file and make the package create the text file locally on the server. Then run the package and verify if it runs successfully.

Then...

To access your existing connection manager, Click on the New button on on the Execute T-SQL Statement Task window to open the Connection Properties window, then type in the name...

This is a good resource to answer your question.

http://msdn.microsoft.com/en-us/library/dd440760.aspx

Cheers!

I'll suggest you test your http connection manager and call the web service using the web service task

to confirm if your package can downlad the required wsdl file that describes...

http://msdn.microsoft.com/en-us/library/dd440760.aspx

I think this video should help you fix the problem you are encountering with your package.

Cheers!

Thanks, now I understand what you are trying to do.

create a variable for your loop counter and map the variable as a parameter to the Execute SQL task just

as...

Can you paint a clearer picture of what you are trying to accomplish? This will be very useful to decide if you are using the right tool for what you...

You cannot overwrite the data in an excel worksheet with

the functionalities offered by SSIS to manipulate excel file.

I will suggest you include a cleanup process in the application

that uses...

Sure you can. You'll have to use SQL Command as you data access mode in your data source configuration, and use the REPLACE function in your SQL code that you...

SSIS is a Microsoft tool for implementing ETL tasks in

SQL Server 2005 and above. DTS was used in versions prior

to 2005 i.e from SQL Sever 7.0 to 2000.

However,...