Sorry it took so long to dig up, I couldn't remember where I'd kept this.

Function Main()



Dim oFS ' FileSystemObject

Dim oFile ' File object

Dim oConn ' ADO...

Useful script ...

Not being totally up with WMI, how would I do it if I was just querying one service? Presumably I wouldn't need the For...Next loop?

Hope this helps

Phill Carter

--------------------

Colt...

Firstly, Ye Gods what a monster. Congrats on the task of working otu the logic to even get the beast running.

Secondly, is all this necessary in one procedure? Could it...

The limit for a varchar field is 8000, if you use the text datatype you can have 2,147,483,647 characters.

Bear in mind that when you use the text datatype you can't...

Make sure your package steps are like this

Text File (Source)

DataPump

Database (Destination)

On Success

ExecuteSQl

On Success

Database (Source)

DataPump

Text File (Destination)

When you create the OnSuccess workflow after the ExecuteSQL task make sure you select the...

Also, make sure the userid has read/write access to the folder. Our IT guys recently spent a few hours tearing their hair out trying to find out why I was...

This little script will set the necessary properties for each connection in your package. Put the script into an ActiveX task as the first step in your packge. Then change...

Is the DSN defined as a User DSN or a System DSN?

Have you tried using a UDL file instead of a ODBC DSN?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original...

Well get to work already, what else have you got to do that is more important

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click...

This only happens with variables. When you try and put too many characters into a field in a table you get a truncation error.

Don't know any workarounf for variables. You...

You can also use the sp_OA procedures, but they tend to be a bit troublesome.

The best approach I've come up with is to setup a scheduled job to run the...

Hmmm ... so they get around it by effectively passing an object to the child package ... interesting.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Good article, one for the trivia buffs

I'd also like to see Part Two, but it should cover the variations offered by different vendors. Might be a...

Good article, although I agree with darren.green, its the DTS Object model that reveals all.

I like your use of the EnumPackageInfos functionality. A number of people don't know about these...

In the reply to screen it has a Screensize option. Can this be used to 'Force-wrap' long lines?

Here's another post that has the same problem

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=16116&FORUM_ID=19&CAT_ID=3

Hope this helps

Phill Carter

--------------------

Colt 45 -...