Viewing 15 posts - 12,511 through 12,525 (of 13,849 total)
Sounds like you got it working well - good stuff:cool:
September 22, 2009 at 8:39 am
An example of your input data would paint the picture much more completely than just words, no matter how detailed your verbal explanation ... So far I have a picture...
September 22, 2009 at 8:35 am
Use an Execute SQL task (select count(*) from ...) to assign the count to a package variable (which you will have to create) at control flow level and then use...
September 22, 2009 at 5:39 am
Or possibly (thinking a level up) a parent package that concurrently runs multiple occurrences of the same child package, with appropriate parameters.
I haven't tried that - and it doesn't sound...
September 22, 2009 at 2:42 am
Elliott W (9/21/2009)
--edit--Maybe you could force the TAB character into a variable and use that variable in the assembly of the column..
--
CEWII
Or put some other unused character there...
September 21, 2009 at 4:00 pm
Assuming that the text files are the same format (same field names, types, number of fields) you can use a FOREACH loop to iterate round the files.
But I'm not going...
September 17, 2009 at 5:11 am
Just add the single quotes in ...
"UPDATE TB_DMNSTAGE SET DMN_STATUS = '" + @[User::DMNSTATUS] + "' WHERE DMN_ID = " + @[User::DMNID]
September 16, 2009 at 4:57 pm
You could use an OLEDB Command transformation to do the update for you.
Or you could send the rows to a staging area and then run an UPDATE to do them...
September 16, 2009 at 12:31 pm
This is somewhat similar to telling someone that your car is not working and asking whether anyone knows how to fix it.
Please provide more details, error messages etc, so that...
September 16, 2009 at 12:16 pm
Easier and cheaper to get an IT-literate temp in for a week, I reckon.
Sometimes the development effort for a one-off task such as this just isn't worth it, IMO. But...
September 16, 2009 at 8:56 am
Create a blank Excel 'template' file - contains just the field names.
0) Copy this file to, say, ID.xls and create a connection in SSIS to ID.xls.
Your dataflow task in your...
September 15, 2009 at 3:23 am
mbricker (9/14/2009)
--snipOtherwise - looks like the data in column 35 is bigger than your destination file is set to handle.
Or that the pipeline meta-data column definition is too small.
September 14, 2009 at 12:11 pm
saidwarak01 (9/11/2009)
I have an assignment like this....
I have table with 100 thousand records with 20 columns and among them there is one column called shcool_id. Now, the...
September 13, 2009 at 11:43 pm
I feel like I'm fighting a losing battle now, but the post I suggested was three above my original post and it mentioned that this was a duplicate thread! 🙂
September 10, 2009 at 10:15 am
Viewing 15 posts - 12,511 through 12,525 (of 13,849 total)