Have you assigned the db_ssisltduser role to the Reader role of the package?

If I understand you're question correctly, you want to insert a value stored in your SSIS variable (app), into the TSQL statement. I'm assuming that you're using Execute SQL...

You can use the Execute SQL Task to run a parameterized SQL statement. You configure the task to specify the SQL Statement with the appropriate parameter marker (depends on the...

You can use an SSIS Expression to replace the double quotes with single quotes.

1. Add a Derived Column transformation to the data flow and connect it to the Flat...

In SSIS 2008, the custom managed assembly can be stored in any folder on your local machine. For SSIS to find the managed assembly at run time, do the following:

1....

There is also the TaskUnZip component available on CodePlex: http://taskunzip.codeplex.com/

You can find tutorials on creating packages in SSIS 2008 in BOL, available on MSDN:

"Tutorial: Creating a Basic Package Using a Wizard"

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

"Tutorial: Creating a Simple ETL Package"

Without being able to see the package you've created, I can't be certain what the problem may be. Have you confirmed that the Excel file you're using is not...

What is the file path (full path) that you're storing in the variable? And, is this an Excel '97 file or a later version?

Did you use an Expression to configure the ExcelFilePath property value of the Excel Connection Manager:

@[<variable name>]

Hi,

When you install SQL Server 2008, you also need to install Client Tools Backward Compatibility.

For more information, see the Installing Support for DTS Packages section of "How to: Install Support...

I don't think there is a 64-bit version of the Data Profile Viewer.

As a general guideline, the account that runs the package as a job step must have all the same permissions as an account that runs the package directly, in order...