I chose not to go the SSIS FTP gui route for various reasons, number 1 reason being that it simply is not flexible enough.

In my case, I had to log...

oiiii,

anywhere 😉 actually just means )

Sorry man

My pivot got chopped....

declare @colList varchar(max)

declare @selList varchar(max)

select @colList = COALESCE(@colList + ',', '') + SchoolDescription

from (

...

hey,

Sample attached

----1) create ddl (i simply inserted into ... values, there were 4 and sue me for being a bit lazy, the date I left as null, all the dates...

:ermm:

Have a look at the following posting

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124560

Hope this helps you

~PD

Readup on this article

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1003049&SiteID=1

Trust this helps

~PD

If the info is not sensitive, please post an example of the source, and the desired destination

Awesome!!!!

:):):):)

I have a team of guys who are seriously smiling this morning because of this posting.

Thanks everyone

hey,

Why dont you first write a query, "select distinct len(emp_id) " to check at the various lengths that you have?

Possibly the length is being reflected as the maximum length.

Also, in...

What caught my eye was that you were optimistic that the files end in "*.dat"

Hope the layout is the same of the files, if not, you will need a connection...

A stop job request was fired, probably by a user?

It does sound like pivot will do the trick for you though

Post a sample datafile, and we will see what we can do for you with pivot

~PD

You would probably have to build a variable which builds the filelist of the directory during the FOR EACH loop step.

Then, you would add this variable to your send mail...

hey,

Not sure if I am understanding you correctly...

First, you have a variable which stores the date you want to compare. For arguments sake, lets call this variable varCompareDate.

Second, you have...

Or alternatively, if your variables are stored in SQL configuration, you could set them in your configuration table, and then call the DTExec which will read from your config table...

Little...