Viewing 15 posts - 11,491 through 11,505 (of 13,871 total)
Use a conditional split to redirect the unwanted rows to an unused output.
April 13, 2011 at 7:27 am
Though this may sound blatantly obvious, did you install BIDS on this machine? 🙂
April 11, 2011 at 2:01 pm
After processing the CSVs, could you rename them to .CSV.[date-time processed]? This, or physically moving the processed files as already suggested, is the easiest way of allowing your FEL to...
April 11, 2011 at 1:58 pm
Script Components have only a single input, so you can't do that. Have you had a look at the MERGE JOIN transformation?
March 24, 2011 at 4:24 am
Yes, I like that solution.
I had a look around for details of what that format function does (when used with a numeric argument) and the best I could find is...
March 24, 2011 at 1:31 am
OK.
If you are checking the value of the variable by looking at the Variables pane after execution of the package, you are looking in the wrong place. When a variable's...
March 23, 2011 at 11:28 am
quillis131 (3/23/2011)
I am new to ssis, i have no idea about method...all i just care is to get the value assigned to Variable Y through the Query
It's not easy to...
March 23, 2011 at 10:55 am
i can't see my variable updated with the value from the result set
What method are you using to check the value of the variable after the update?
March 23, 2011 at 10:36 am
1. This is a 2-year old thread.
Damn, missed that!
March 23, 2011 at 4:07 am
KrishnaChaitanya (3/23/2011)
I have an SSIS package which loads data into SQL server database. In the excel file, one of the column contains big integer values (e.g: 5012170). When the SSIS...
March 23, 2011 at 2:25 am
Tom Van Harpen (3/10/2009)
I have a staging table and the production table. I use a conditional split after a merge join (left outer) to determine if the row exists in...
March 23, 2011 at 1:33 am
I'll bet you're hoping that the input file won't get a load of extra columns added any time soon!
Too bad we can't write user-defined functions in the derived column editor...
March 23, 2011 at 1:21 am
Please post the full text of the error.
Which component is the cause of the error?
Please post the formulas for the expressions you have used.
--Edit: for those who are too lazy...
March 21, 2011 at 1:23 pm
I agree with all that, except that this looks like an ActiveX DTS script - is that correct? If it is, a straight rewrite in C# is a waste of...
March 21, 2011 at 9:19 am
You haven't really answered the question - please look at it again. There is an article here which may give you some useful information about query analysis.
March 20, 2011 at 12:36 pm
Viewing 15 posts - 11,491 through 11,505 (of 13,871 total)