Viewing 15 posts - 8,716 through 8,730 (of 9,715 total)
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
The .dll might need to be registered in your server.
Open the command prompt. Type in regsvr32 (flag list) (.dllname)
The flag list is as follows:
/u Unregister Server
/s Silent; Display no...
August 5, 2008 at 7:14 am
The simplest way is to use 2 queries in an IF / ELSE statement.
IF X = 'TRUE'
Begin
Select * from TB1
End
ELSE
...
July 30, 2008 at 4:32 am
Dean,
You are missing table aliases in your code. Look for every instance of the table name in the FROM statement or the JOIN clauses to make sure that you...
July 28, 2008 at 7:18 am
I'm actually playing with the VNF right now with my DW solution. I've just started altering the schema and doing the coding. I'll keep everyone updated as to whether or...
July 28, 2008 at 7:15 am
Definitely put together this utilization stuff for an article, please. That would be FANTASTIC.
July 28, 2008 at 3:50 am
Viewing 15 posts - 8,716 through 8,730 (of 9,715 total)