Viewing 15 posts - 1,096 through 1,110 (of 3,666 total)
BobMcC (3/2/2011)
The file names correspond with the SQL tables they need to be loaded...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 2, 2011 at 3:42 pm
Phil Parkin (2/15/2011)
IMO this might be simpler if implemented in a Script Task.
That's what I would do.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 22, 2011 at 3:49 pm
SQL Dude-467553 (2/22/2011)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 22, 2011 at 2:15 pm
SQL Dude-467553 (2/22/2011)
I've created a SSIS package that
1. Calls A stored procedure in the ExecuteSQLTask
2. That ExecuteSQLTask has the Result Set Type = "RowSet"
3. I...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 22, 2011 at 2:04 pm
I probably would use a flat file source to read the data as one column. I would then feed that one column to a script component where I would...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 22, 2011 at 1:16 pm
gladiatore85 (2/21/2011)
Anyway i've found solution using a temp recordset, i select every distinct categories, then i loop...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 22, 2011 at 10:03 am
Dolson Sebastian (2/17/2011)
to fail the container on a failure, the best option is failparentonfaliure=true... i agree...i was thinking about catching the error and continuing the flow. 😉
The original post says:...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 22, 2011 at 9:53 am
The "base" is what most things "sit" on, so be careful what you touch! 😀
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 18, 2011 at 10:03 am
I'm really surprised that SSIS packages are not more self aware at runtime. Hopefully there will be some improvement in 2011.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 18, 2011 at 7:35 am
Have you tried replacing MyVariable with the variable names?
Also, take a look at DTExecUI. It can be a real savior sometimes for generating the command string for you.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 17, 2011 at 12:17 pm
They exchange camels too??
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 17, 2011 at 12:07 pm
What does all of this have to do with Integration Services?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 17, 2011 at 11:57 am
In the Control Flow, you could add a ForEach file container to hold your dataflow. Have the ForEach container pass the file name to a variable. Use that...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 17, 2011 at 10:09 am
gladiatore85 (2/17/2011)
I'm working on SSIS 2008.
I have a parametric stored that results a multiple recordset.
Now i want...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 17, 2011 at 9:15 am
Please avoid posting the same question in multiple forum sections.
Please answer my question in your other post.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 17, 2011 at 8:55 am
Viewing 15 posts - 1,096 through 1,110 (of 3,666 total)