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...

Opps. Ignore the "environment variable" comment. I think you'd have to choose "SQL Server" in that dialogue box.

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...

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...

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...

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)...

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...

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...

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...

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...

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...

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...

The simplest way is to use 2 queries in an IF / ELSE statement.

IF X = 'TRUE'

Begin

Select * from TB1

End

ELSE

...

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...

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...