skcadavre (9/9/2010)

True. I didn't really look at the format...

3 of us posted an answer, but I think I'm the only one with the right format. (120 vs 102)

dave-dj (9/9/2010)

this sounds simple, but I can't seem to get it to work.!

I have a store procedure that basically generates a date, that needs to be put into a database...

Have you looked at DateAdd?

As you probably already know, DTS was not made for looping.

I would probably do the looping inside an ActiveX script and have the script call the next step, passing the...

Jack Corbett (9/9/2010)

Alvin Ramard (9/9/2010)

Alvin Ramard (9/9/2010)

Looks like someone was really...

Steve Jones - Editor (9/9/2010)

My wife got me a new hat this past weekend. I was wearing it when I went to take...

ARGH!! Hit by the quoting the wrong post, again!

Move on, move on. There's nothing to see here. 😎

Brandie Tarvin (9/9/2010)

Hey! This group is psychotic!

... um, psychic. I meant...

Looks like someone was really linked in. 😛

I would use a script task in the control flow.

The .NET code should read the first line; count the number of delimiters; set variable equal to the count. (How?...

slakhanp (9/9/2010)

The Simple logic for this Package is that While reading data from flat file use row count transform.After Reading data from flat file using data flow task.Use expression...

2 options come to mind.

1 - Use a .NET (VB or C#) script to password the file via Excel.

2 - Password the file via a file compression program...

I agree, but it's not that bad if you think about it before you start. There's lots of benefits...

Jeff Moden (9/8/2010)

Yep... sometimes I forget that even though this is a water cooler forum,...