Viewing 15 posts - 8,716 through 8,730 (of 9,720 total)
The OLE DB Command in Data Flow works on a Row By Row basis. RBAR at its finest. @=)
If you have something huge to update, you're better off trying to...
August 26, 2008 at 5:18 am
I don't know about the second one, but I think you need to write some SQL code to "ping" the server or do a simple select statement on a small...
August 26, 2008 at 5:16 am
I understand your boss's problem and here's the simple solution to maintain performance and to make him happy.
Take all the code in those Execute SQL Tasks and make them stored...
August 26, 2008 at 5:14 am
Great. Yet another thing to delay the conversion of our "end of lease" box. Boss is going to love this one.
I voted on the issue and commented. I guess I'd...
August 26, 2008 at 4:44 am
I've looked around and can't seem to find anything about creating the variables at run time. I'm sorry. The closest I can come is Dynamic SQL which you could stick...
August 25, 2008 at 12:57 pm
Opps. Ignore the "environment variable" comment. I think you'd have to choose "SQL Server" in that dialogue box.
August 25, 2008 at 11:39 am
Jane,
You might be able to create the variables in a SQL Table that is accessed by a config file. That way, you don't have to create each variable inside the...
August 25, 2008 at 11:38 am
Jane,
You do have to create the variable at package creation time. However, you can wait to populate it, or repopulate it, at run time. So the workaround is to...
August 25, 2008 at 7:20 am
Huh. Looks like I owe you coffee. @=)
I never even noticed the Mobile thing. That explains a lot. It's also incredibly annoying. But I think it...
August 14, 2008 at 3:45 am
Curiousier and Curiousier... It is NOT there in the July 2006 version. The only code examples I see are:
A) with the Alter Table Alter column to set an identity
B)...
August 13, 2008 at 10:34 am
You're not miles off. That is EXACTLY what I forgot. DOH!
I looked and looked in BOL, but it doesn't have this as a code reference. I even...
August 13, 2008 at 10:11 am
Ahha. I just figured it out. You can't do multiple dts packages when they're stored as Structured Storage Files. You can only do it when they're stored...
August 12, 2008 at 4:48 am
Anli,
Check Steve Jones' list here http://www.sqlservercentral.com/articles/Administration/2960/ and follow his links to see if there are any SSIS components for the fixes after build 3042.
Note that the builds go from Highest...
August 11, 2008 at 12:03 pm
The service pack should include all the relevant component upgrades, including SSIS. If yours didn't upgrade properly, this tells me either your SSIS is on a different server or...
August 11, 2008 at 10:42 am
You could read the record sets to an ADO recordset in your dataflow, then use rowcount variables (there would have to be 7) in the same dataflow to count each...
August 11, 2008 at 10:38 am
Viewing 15 posts - 8,716 through 8,730 (of 9,720 total)