Aren't these cheese puns just grate? I Swiss there were more of them, just not too many to get Feta up of them.

I Camembert-lieve how many you can fit in...

Replace the temp table name with that of an actual table temporarily, you can then set the parameters and change the name back.

It's a slight quirk of the DTS designer...

Except sweeping the floor??? Lucky {expletive deleted}!!

:P:hehe::w00t:

Hey,

Blackle is actually provided by Heap Media, a company in Sydney, Australia. The searches are powered by Google custom search.

😉

Squeal? Ace!! :w00t:

That can go in the book with the age old Query Demonizer and Enterprise Mangler. 😀

I don't think that you can do this all at once. What I do with my portable packages is start with a dynamic properties task that looks at a INI...

.. ahhh, but not as nifty as the SQL version!!! :D:hehe:

I use 'sequel' on the odd occasions that I have talk to non-technical types. Throwing TLA's at them doesn't seem to go down well; confusion, apparently, doesn't rule?!?!

Otherwise it's the...

Hi Jane,

Firstly, good luck with the project; I'm sure that there are plenty of guys on here that can provide some help at sticky points.

As for the unsupported Sql Server...

You can use a GlobalVariable and either an ActiveX script or a Dynamic Properties task to change any connections.

HTH,

Hi,

I use 7-Zip's command line interface through xp_cmdshell to do this for a number of processes here.

HTH,

Me again,

I think I've recreated the problem with the data you pasted...

I believe your problem lies on the Select File Format screen where you've put:

Try the following...

Hi,

Is it case of mistaken terminology? The comma is the column delimiter and the carriage return/line feed is the row delimiter.

Ade

Hi,

I'm not aware of anything off-the-shelf but it is easy enough to use SQLmail and SQL Server Agent to build a quick app. I've built one in 2000 (works in...

After the discussion that this has escalated in to, most of you guys have had more than 2 points added to your site scores anyway after all your posts.....

I thought...