I like Option#3. It seems more straigtforward and should run faster as well.

Thanks for the feedback.

The answer is "maybe".

It depends on type of index and data distribution. If you query on A, and there are large numbers of repeating values of A in...

Thanks for the responding to my post.

Adding a "distinct" to the query might be helpful in case a person bought more than 1 item of the same type on a transaction. Say a person buys 2...

Thank you Sergiy. I should i have read the link properly - it did answer my question.

Thanks.

Thanks for responding.

The group by query is useful. But, i need to futher filter the join table by the CrDate. From the join table I need to fetch only those...

You can write a .NET program or VB program that would dynamically load the .NET package and use the DTS object model to manipulate the data source property of each...

Try generating text files or excel files out of the AS400 database and then use DTS to import the data in the files to SQL server tables.

Hope this answers your...

Thanks to all for your inputs.

I knew that i could do it by using a separate IN clause for each column, but i felt that the  syntax WHERE (a,b,c) IN (1,2,3) ...

I figured it out myself after some trial and error.

Initially I had set the path to the UDL file to directory "A".  At that time i was not using the...

Thanks for the response.

The tempdb is 955 MB in size and the hard disk is 33 GB (12 GB free space). Its our development database machine.

Please pardon my lack of...

To stop your DTS package , you need to flag the step to say that the DTS package should fail if the particular step fails.

In case of Activex Script task, if...