Viewing 15 posts - 121 through 135 (of 3,232 total)
You're going to have a difficult time with that in SSIS. SSIS is extremely metadata sensitive and must be mapped directly to both the source and target objects. ...
March 29, 2016 at 10:53 am
It's not really dynamic since you know which columns each provider needs to populate. This can easily be done via SSIS. You just need to create a separate...
March 29, 2016 at 9:12 am
I agree with Brandie here. All of this can be done in SSIS with the native components. The biggest challenge is file formats. You'll need a dataflow/loop/package...
March 29, 2016 at 9:02 am
REPLACE does not allow for wildcards. What you'll need to do is identify the starting position for where you want to replace and either use LEFT or SUBSTRING to...
February 2, 2016 at 11:03 am
No worries, it's all part of learning. Just a suggestion, keep in mind that variables are also set quite often via expressions. I know this one was a...
February 1, 2016 at 3:03 pm
I'm not sure I follow you 100%, but I'll give it a try. For starters, you cannot override an existing toolbox component as far as I'm aware. You...
February 1, 2016 at 2:13 pm
OK, I'll step it out for you.
1. Add a Send Mail Task to your Control Flow, connect it after success of the previous task we set up (Execute...
February 1, 2016 at 1:46 pm
You won't need the Row Count Transformation for this. Do the following:
1. Create a Variable of type int to hold your count value in.
2. Add an Execute SQL task...
February 1, 2016 at 1:10 pm
I prefer the middle example using COALESCE. The problem is that your COALESCE is mal-formed. You don't need the first argument. Change it to this and it...
February 1, 2016 at 12:21 pm
Hey Meatloaf...sorry for the delay, I was tied up Friday and out yesterday. So you've got two things that could be wrong here. Either you placed your expression...
October 13, 2015 at 2:19 pm
It is the FTP Connection Manager that needs configured, not the FTP task. My last post discussed this. If you look at the expressions on the connection manager,...
October 9, 2015 at 10:48 am
The import/export wizard uses SSIS and allows you to save the package off. You could use that to do your first run, then save it off and use it...
October 8, 2015 at 2:51 pm
You'll need a variable for each of the column names in your select list. So your initial query will load your object variable with the dataset results from the...
October 8, 2015 at 1:42 pm
Right click the FTP task and go to Properties. This brings up the Properties window. Look under Misc for Expressions...click on the ellipse in the Expression value box....
October 8, 2015 at 11:35 am
Here's a walkthrough that shows exactly what I'm talking about.
https://www.simple-talk.com/sql/ssis/implementing-foreach-looping-logic-in-ssis-/
This would require that you've stored all of your FTP connection info in a table.
October 8, 2015 at 10:35 am
Viewing 15 posts - 121 through 135 (of 3,232 total)