Thanks for the reply.

Yes, I tried the export wizard, which is what I use for casual one-off exports.

This is more complicated - three different files exported every day at...

OMG - the source is a view and one column name changed.

I set the ValidateExternalMetadata property to False and the error went away.

Now I only get an error on the...

The dynamic connection is the destination - a flat file.

OK, I doubled up on the slashes within the path, and put four slashes at the beginning to indicate the UNC path. My expression evaluates to this.

\\johnson\clientFTP\users\UBM\ATOM\GEN_V2_DAT_ENT_IUXA9_PRE_20121101_888888.txt

I set the connection...

I'm following what you are saying about setting variables, etc.

I'm using variables to set different pieces of my connection string

"\\johnson\clientFTP\users\UBM\ATOM\GEN_V2_DAT_ENT_" + @[User::ShowIdentifier] + "_PRE_" + @[User::TodayDateOnly] + "_888888.txt"

Note that...

Dave, I would like the expression for creating an expression based on a date.

First, based on today's date as I expect this would be simplest,

then based on a date parameter...

Didn't work.

Getting this

...is too long. Maximum length is 128.

I use a view for the data, which is short enough.

It's getting the column names output that is causing me problems.

I'd...

Perfect! I can put this in an SP and just schedule that.

SSIS is giving me conniptions ; I'd like to stay in my comfortable T-SQL world where I am master...

Did you get any replies to this topic?

I, too, prefer to contain all the logic in a stored procedure rather than fuss with an SSIS package.

Colleen

Women want to stop playing these games and just do the job.

Will that day ever come?

wendyp (10/4/2010)

Craig Farrell (10/4/2010)

Bottom line here is that women aren't bitching and moaning (don't recall who used that phrase...but it's up there in the commentary). There truly is a stereotype...

David, you should live in Maryland, where jousting is the state sport (seriously!). Various guys I know are involved in Dagorhir or Civil War enactments, etc. Lots of IT guys,...

In principle I agree with the idea that men and women complement each other.

However, by many standards I (female DBA, fifties) am a geek, a techie and can step on...

Seventies-era DBA responding here...

Here's a telling difference - I take drumming lessons so I can play in a pipe band with the boys. At my last lesson my teacher asked...

Bravo! Exactly the same situation here - the DBAs are females from the seventies, the network guys are younger and, you guessed it, all guys.