1. Yes. The query optimizer will analyze the query, the table/index structure, and the data distribution and determine the most optimal query plan for that query. So you...

Phil's suggestion would be a good option as well. You'd just need to put in some logic to count up your error rows in the data flow as they...

Have you tried importing it from your SSIS instance?

Try deploying it to your SQL Server without copying the files first.

Alternatively, you can connect to your production SSIS instance and import the package there.

Are you saying that you've copied all of this to your production server's C:\SSISPackages directory?

You don't need to copy the .dtsx, .config, and manifest anywhere. Use the deployment manifest...

Google SSIS package configurations and you'll get a heap of info. Here are a few worth reading:

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

http://www.sqlis.com/post/Easy-Package-Configuration.aspx

http://www.sql-server-performance.com/articles/dba/package_configuration_2005_p1.aspx

1. 1400 emails - what's wrong with that? Just kidding! I've used this before and only the first error triggered the OnError event handler. You may check...

Well, we know that you can use the Send Mail task in both the Control Flow and in the OnError event handler. You could route the missing lookups from...

Read up on package configurations. This will allow you to set your package up to pull in values from environment variables, registry entries, xml files, etc. You should...

Duh, I didn't even think that the forum might have pulled the tags out!!

Yes. If you want to copy data to another DB and transform it in the process, SSIS is the tool of choice.

However, if won't be easily picked...

If so, you can't query the XML because there are no nodes defined. You'll need to convert it to a varchar and use standard character handling functions.

SELECT...

Is that really how the XML data is stored?

Shamshad Ali (8/31/2009)

---

First of all thanks for your reply and help. I am giving you reply to your questions in steps below:

[Some of that depends on how you will be...

Good catch Phil. You are absolutely correct, I meant can't. Thanks for catching me!