Viewing 15 posts - 11,491 through 11,505 (of 13,876 total)
"Didactic" - as in instructive? Do you mean that those people using between should receive instruction before doing so? 🙂
BETWEEN works fine as long as you know what you're doing...
April 14, 2011 at 10:19 am
SSIS can move data around as much as you want, but if you are new to the product you are going to have to spend some time getting up to...
April 14, 2011 at 9:45 am
sri.gads (4/14/2011)
April 14, 2011 at 8:38 am
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
Viewing 15 posts - 11,491 through 11,505 (of 13,876 total)