Viewing 15 posts - 11,476 through 11,490 (of 13,858 total)
What's the source of the data? If it's SQL Server, you can solve this using appropriate T-SQL when you select the source data.
April 14, 2011 at 4:44 am
quillis131 (4/13/2011)
before bothering you again, i will check with team that can take care of this ...but what should i tell them. Should i explain...
April 13, 2011 at 9:52 am
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
Viewing 15 posts - 11,476 through 11,490 (of 13,858 total)