1. Create a package variable named "ExecuteSQL" as a type of "String" (http://technet.microsoft.com/en-us/library/ms141085.aspx)

2. You can set the value using an expression (when the variable is selected in the variables list,...

Glad to provide some help. It's definitely a different world moving from DTS to SSIS.

Another place worth looking is http://www.jumpstarttv.com. There are some videos that show...

Boy, there are so many ways that can be done...

It's a pretty basic set of tasks for SSIS to perform. I can point you in a direction, but you...

Forgive me if this comes across as too "Tech Support 101", but have you checked to make sure you don't have a typo in the stored proc name?

Does the stored...

ActiveX is one of the things that went "Bye-bye" when SSIS came around. Scripts cannot be migrated to SSIS.

There is a backward-compatible tool that allows you to run DTS...

Thanks Marrianne!

I'll give it a shot and let you know how it works!

Dan

Unfortunately, that is correct. VS2008 cannot edit SQL 2005 SSIS packages. You...

"The Microsoft Data Warehouse Toolkit" by Joy Mundy and Warren Thornthwaite gives a good overview of DW/BI from a Microsoft-centric viewpoint.

Amazon's Product Link

Oops - missed that last note... :blush:

I think including the blank values in your SQL source statement IS having SQL do what it is supposed to do. Your client...

Is your source a SQL table? If so, are you using a SQL query for the source query (rather than table or view)? I always try and use...

Thanks for the responses to this post. I finally got it resolved.

It turns out my XML editing skills are lacking. When I edited the email setup using the...

If you are a complete Microsoft shop, I would also recommend (in addition to the Warehouse Toolkit RBarryYoung suggested) the Microsoft Data Warehouse Toolkit.

Also, I have a very important point...

One perfectly acceptable case where this format would work is in a Date dimension for a data warehouse environment.

While it is advisable in most cases to use a...

You can base the parameter values on a query (rather than non-queried) and use a dataset to generate the values.

Then you have the full capabilities of T-SQL at your disposal.

I found a set of reports that provides the type of functionality you are looking for. It's part of the online tools for the Kimball Microsoft Data Warehouse Toolkit.

The...