Well, the easiest way is to use the date/time in the filename.

Will that work for you?

There isn't a built-in way to do it but you do have choices.

You can go with SMO which has a script method, but SMO has always been a little hard...

You can write a logon trigger that checks the app signature. Only instead of checking for apps they're not supposed to be connecting with just check for yours and...

I haven't seen this exact problem, but many just like it. That's why I don't use maint plans.

I almost sounds like you're giving advice more than asking for advice, but I think there's maybe a language barrier there. However, I'm going to assume you're asking for...

I have a video on oledb connection mgr and config files... the concept is the same for files.

check it out if you like...

http://midnightdba.itbookworm.com/SSISConfigFileConnString/SSISConfigFileConnString.html

I've got a couple videos on BCP if you like...

http://midnightdba.itbookworm.com/index_files/Page380.html

Well, the IsSorted flag just tells downstream components that your data is sorted. It doesn't actually sort it. It will have no bearing on performance.

Y, I have no idea. I've been pulling from views for yrs and I just did a test with a relatively complicated view and it pulled back just fine....

The first thing that comes to mind is maybe the file doesn't exist. It's possible that you're running the package on your workstation but the file is on the...

I have a video on how to use the rowcount.

http://midnightdba.itbookworm.com/SSISRowCount/SSISRowCount.html

I think you've basically got 3 options:

1. Set option explicit off. you can do this at the top of the script above the import statements by typing "Option...

Are you positive that you're logging in with the same creds? Perhaps SSIS is making an anonymous connection which doesn't have permissions...

I would imagine that if you just put a rowcount in front of your error file dest you can retrieve the var that holds that count in the next step...

Here's what you're looking for...

([Column 2] == "N/A" ? "0" : [Column 2])

What this says is if col2 equals "N/A" then make it "0", else leave it as col2...

This goes...