Viewing 15 posts - 8,731 through 8,745 (of 9,725 total)
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
And if your tempDB is full, no query you write on that SQL Instance is going to work. All databases utilize TempDB to some extent (even if you don't...
July 24, 2008 at 11:00 am
Dean,
Unfortunately, a generic "I'm getting errors" doesn't give us anything to go on. We're not going to do all your work for you. If you want the correct...
July 24, 2008 at 10:32 am
It Depends... (a DBA's favorite answer).
There is no right or wrong way in this situation. There is only your situation.
My advice is to set up a job...
July 24, 2008 at 8:13 am
GilaMonster (7/24/2008)
Brandie Tarvin (7/24/2008)
Sheer laziness or the inability to properly determine the growth rate of your DB. @=)
My main system is more a datawarehouse than anything. It grows and...
July 24, 2008 at 7:56 am
20GB should be fine so long as you don't put any SQL Server databases (including system DBs) on your C: drive.
Usually I reserve C: drive for the OS and for...
July 24, 2008 at 7:51 am
Viewing 15 posts - 8,731 through 8,745 (of 9,725 total)