Viewing 15 posts - 1,021 through 1,035 (of 3,232 total)
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...
September 2, 2009 at 8:42 am
Have you tried importing it from your SSIS instance?
September 2, 2009 at 8:25 am
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.
September 1, 2009 at 3:31 pm
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...
September 1, 2009 at 3:10 pm
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
September 1, 2009 at 3:05 pm
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...
September 1, 2009 at 3:00 pm
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...
September 1, 2009 at 1:21 pm
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...
September 1, 2009 at 1:11 pm
Duh, I didn't even think that the forum might have pulled the tags out!!
August 31, 2009 at 4:38 pm
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...
August 31, 2009 at 4:29 pm
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...
August 31, 2009 at 4:24 pm
Shamshad Ali (8/31/2009)
[Some of that depends on how you will be...
August 31, 2009 at 3:59 pm
Good catch Phil. You are absolutely correct, I meant can't. Thanks for catching me!
August 31, 2009 at 1:32 pm
kabaari (8/31/2009)
Thanks. That's definitely easier said than done. I will try to post sometime today. S2K5.
Maybe, but with what you are asking for, someone will have to mock up an...
August 31, 2009 at 12:09 pm
Viewing 15 posts - 1,021 through 1,035 (of 3,232 total)