I think you have to generate the XML file first and then use an XML source adapter to connect the XML file. In the XML Source Adapter there is an...

Hi Michael,

You can use the variable expressions within the precedents constraints. You can store the results you want to check into a variable and then use this variable in an...

Please refer to the following website:

http://www.mssqltips.com/tip.asp?tip=1084

Hope this will help you further along

Hi,

I'm not that familiar with AS, except for testing and playing around with it. I more into Cognos.

But you can also search http://www.wrox.com

I find the books from...

Well, then I can recommend for sure the following books:

Professional SQL Server 2005 Integration Services: http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764584359.html

Expert SQL Server 2005 Integration Services:

http://www.wrox.com/WileyCDA/WroxTitle/productCd-0470134119.html

The Microsoft Data Warehouse Toolkit:

Hi vijay,

What you can do is to add a line in the Preparation SQL task to check if the table already exists in the database:

IF OBJECT_ID('dbo.TableName') IS NULL

...

Hi vijay,

You have to modify the package you created with the wizard (are you familair with SSIS...??). This Execute SQL Task have to be removed as soon as you've created...

Hi Mike,

Why don't you give the add an alias to the query. Now the lookup doesn't know what the name of the column should be to display to you.

SELECT ISNULL((SELECT...

Hi vijay ,

Did you just run the Import and Export Wizard without any modifications to the package, because it will add an Execute SQL Task before the Data Flow Task...

Thanks,

We indeed solved the problem by using the config file.