Hi Valek - there is a messy way to do this. I wrote a post about it here[/url]

Cheers

There is a way that it can be done, but its messy... you use the bulk insert task, or if you want to output the data, use bcp and an...

Yeah, I remember when we completed our migration to 2K5, we had to run one machine on 2000 just so we could fix or change any DTS packages that were...

It sounds like you've done a lot of work on this... I regret to have to tell you, but you can't dynamically change the meta data of an SSIS dataflow.

The...

It definately works... just tried it again and can load multiple packages from file, local storage or dtsbackup format.

Have you tried DTSBackup? I think I got that to work when I was doing a migration...

I think there was a third party tool I used when I did a migration from 2k to 2k5. Have you tried dtsbackup?

Pretty sure I was able to make that...

Hi,

I'm not sure where you got to with this, but I thought I'd give you a few pointers... If you're using the send mail task in SSIS you will find...

You're quite right,

If the variable you are concatenating isn't of the same datatype as the expression result then you need to cast it. To do this place a typecast...

Hi,

You will find that when you create the dtsconfig file, you will have a config entry for the password (provided you've selected it as one of the properties), however the...

There are a number of ways you can do this. The one I think would be best in your situation is the T-SQL OUTPUT clause new in 2k5. With this...

I don't think you'll need a function for this... Try making /N the column delimiter in your flat file.

Hi,

It doesn't look like the string has been constructed properly. Its missing quotes and concatenation...

"SELECT KALKYL.ORDER_NR, KALKYL.POS_NR, KALKYL.TIDPUNKT_UPPDAT

FROM ABC.KALKYL, ABC.KALKYLSTEG_RES, ABC.KALKYLSTEG_VER, OG07.TALEVERANS_POS

WHERE ABC.KALKYL.KALKYL_ID = ABC.KALKYLSTEG_RES.KALKYL_ID AND

ABC.KALKYLSTEG_RES.KALKYLSTEG_ID = ABC.KALKYLSTEG_VER.KALKYLSTEG_ID AND...

Hi Cory,

Thats right - you may need to change it to vbCRLF, vbNewLine or whatever the special character happens to be. (If you hit F1 when your cursor is on...

Hi Cory,

My apologies, the explanation wasn't particularly detailed.

1st thing to do is drop the script component editor on the the dataflow, between your OLE DB Source and your flat file...