Viewing 15 posts - 12,151 through 12,165 (of 13,427 total)
Don't know, but why don't you just give it a try and see what happens? It's not difficult to set up a test.
August 12, 2009 at 2:08 am
Or, if you can be bothered setting things up so that you have access to the Excel object model via script (a bit of a pain), you can get the...
August 12, 2009 at 1:54 am
roundel1900 (8/11/2009)
gah (8/11/2009)
In Control Flow create an "Execute SQL Task" ...In the task editor set the SQL Statement to TRUNCATE TABLE "yourtable"run this before your dataflow task
I don't...
August 11, 2009 at 11:51 am
Do I have to do everything? I said it was untested and expected that you could work it out ...
Turns out there is no LEFT function available, so you'll have...
August 11, 2009 at 10:34 am
Ah - you said you were having a problem stripping off leading zeros and that confused me, but now I understand.
So you need something like (completely untested)
LEFT('00000', 5 - LEN(Zip))...
August 11, 2009 at 10:00 am
OK, I think an easy way to do this is to put in a data conversion transformation and convert from your current string field to an integer - this will...
August 11, 2009 at 9:51 am
If you really appreciate problems, I have some really juicy ones for you :laugh:
Can you provide sample data - source and required output - please? I'm English & not really...
August 11, 2009 at 9:38 am
Can you throw away the old record, if a newer one exists, and just use the newer one for everything?
August 11, 2009 at 8:07 am
OK, just tried this with my own system:
"select f1, f2 from account where accountid = '" + @[User::AccountID] + "'"
is the value of SqlStatementSource, under Expressions.
August 11, 2009 at 8:02 am
Did you try using the 'Expressions' property as I suggested? Otherwise your statement will not get evaluated ...
You will be able to paste your variable into your SQL statement using...
August 11, 2009 at 6:46 am
roundel1900 (8/11/2009)
August 11, 2009 at 6:20 am
Did not! 🙂 'This' is a hyperlink in my post. Happy hunting.
August 11, 2009 at 3:30 am
It is likely that you can use an Expression to set the SQLStatementSource property to get what you want, without the need for all the faffing around you mention in...
August 11, 2009 at 2:54 am
Not easy. You'll probably need to get hold of the Excel object model and manipulate the spreadsheet via a Script task before and after the updates to get anywhere with...
August 11, 2009 at 2:41 am
Appending rows is the default behaviour. Any other requirement (UPDATE or replace, for example) would require additional steps.
Unless you are prepared to take the time to provide a few more...
August 11, 2009 at 2:28 am
Viewing 15 posts - 12,151 through 12,165 (of 13,427 total)