Viewing 15 posts - 11,221 through 11,235 (of 13,872 total)
You can't do that - all of your field references will be to the situation as it was 'before update'.
So you need to write things out in full rather than...
August 1, 2011 at 8:38 am
Not sure I understand.
Use SELECT instead of PRINT?
July 30, 2011 at 5:00 am
What do you mean by 'not working'? Wrong result, or error? If error, please post the error.
Have you considered doing this in T-SQL as part of your select?
July 30, 2011 at 3:01 am
TTboy (7/29/2011)
Mainly I have 2 tables: TableA and TableB.
A record in TableA can have...
July 29, 2011 at 9:30 am
Edward-445599 (7/28/2011)
steveb. (7/28/2011)
one way is to write an update or delete statement in the ole destination and use this in...
July 28, 2011 at 3:01 am
steveb. (7/28/2011)
one way is to write an update or delete statement in the ole destination and use this in the...
July 28, 2011 at 2:50 am
What I need to do is send an email based on teh value of that variable.
You can use precedence constraints to control which logical path an SSIS package follows. So...
July 27, 2011 at 1:56 am
Can you just scan the results of the queries by eye to determine which is behaving unexpectedly?
Once you know which query is returning the wrong results, it will be easier...
July 26, 2011 at 5:37 am
Yes - or maybe a better editor like Notepad++. Even better, MS Access.
July 26, 2011 at 2:07 am
I'll state my position on this, and I know I am not alone.
If you need to store and analyse hundreds of thousands of data rows, use a database.
If you want...
July 26, 2011 at 1:37 am
SinisterPenguin (7/25/2011)
July 25, 2011 at 2:03 pm
It would also help if you would explain 'in English' what that expression does, rather than leaving it as SQL puzzle of the day, to help those here who do...
July 25, 2011 at 7:58 am
Is your source and target data all on the same SQL instance? If so, may I ask why you are using SSIS for this?
July 25, 2011 at 7:45 am
If a foreach loop has nothing to process, execution transfers to the next task. So I suspect that there is something in the logic of your package which is causing...
July 21, 2011 at 10:56 am
Please describe in more detail what you want to achieve.
Include an idea of what the data source and destination are - is this all in SQL Server?
July 20, 2011 at 6:47 am
Viewing 15 posts - 11,221 through 11,235 (of 13,872 total)