Mary,

I don't understand. You say it currently comes out as seg_idem_20060327.txt. That looks as though it has a 2-character month to me.

What do you want it to look like?

-Jamie

The OLE DB Command transform is used to do UPDATEs from the pipeline.

Unfortunately it suffers from a problem that I am told INFA has as well, UPDATEs are issued a...

Mike,

There's a little button that apears when that property is highlighted. Click it and you'll go into a Notepad-alike editor. Not great but better than copying/pasting.

-Jamie

Open up the derived column transform. In the top left segment expand variables and drag the variable you want into the lower window. That'll create an extra column with the...

Dan,

By and large I'm a supporter of the Feedback Centre but if you don't give us feedback on what we submit then its little better than SQLWish.

As I said here:

I think BOL is massively improved in SS2005 but there are alot of gaps. Many pages about object properties just give the bear minimum of information and don't actually include...

GOD YES!!!

BeachDBA - you've nailed it. Couldn't agree more!

-Jamie

AHA. Yes, it all comes flooding back now.

Here is how you deal with this in SSIS: http://www.sqlis.com/default.aspx?311 There are 2 methods here - I recommend you use method 2.

Its a...

No problem.

http://www.sqlservercentral.com/forums/messages.aspx?forumid=17

Or try: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=83&SiteID=1

-Jamie

Can you expand on what DD_UPDATE is? I have a vague recollection of it from my INFA days of 2 and a half years ago...but can't properly remember.

-Jamie

Hi,

I guess its a matter of opinion and the best answer anyone can give is "It depends". However, I've posted a list of things to consider up here: http://blogs.conchango.com/jamiethomson/archive/2006/03/14/3080.aspx

Note,...

Ooo, fun. This could go on for ages.

My bug bear is an SSMS thing as well. You used to be able to script out a whole bunch of tables at...

That's a very strange error. I'm afraid I can't help with that.

I did want to point out this very important article regarding the execution of packages from SQL Agent though:...

Trying the Analysis Services forum would be job 1!

-Jamie

Another here: http://blogs.conchango.com/jamiethomson/archive/2005/07/04/1748.aspx with a downloadable demo.

-Jamie