Which property are you trying to set?

You can do this with a simple Execute SQL Task and a precedence constraint with an expression. In your Execute SQL Task, configure an output variable (under the Variable...

Can't tell a lot from what you've provided here, but one thing that stands out in your error text is that you're using a SQL Server Destination. While this...

Mark,

Assuming you want to archive the file based on the date stamp of the file (rather than the header data of the backup itself), you can use a script task...

Excellent. Let me know if you run into similar problems.

For the second issue (missing delimiters), I think you may be confusing delimiters with qualifiers. Delimiters separate values within your text, but qualifiers sort of do the opposite, keeping...

Sorry, duplicate file upload... I did this once and it appeared to hang before the reply was done.

For the original issue, unfortunately I don't have BIDS 2008 on this dev machine. I'll attach the C# code snippet, which will hopefully give you some insight into what...

Sorry for the delayed response, I've been at the SQL PASS summit and a bit behind on replies.

You're actually closer to a solution than you think...

If you're mapping the file...

You can do this with a precedence constraint. I wrote a blog about this method recently: http://www.sqlservercentral.com/blogs/tim_mitchell/archive/2009/9/16/skipping-items-in-a-foreach-loop.aspx

Ping me again if I can help further.

hth,

Tim

Strick,

I'm not clear on what you're trying to do here. Could you post some more information about what you're trying to accomplish?

hth,

Tim

You bet, it's pretty simple to do.

Set up a package-scoped variable of type Int32 to store your row count. In your data flow, drag across a row count transformation...

Could be a version incompatibility. What version of BIDS (Business Intelligence Developer Studio) are you using? The sample was developed using BIDS 2008.

You'll most likely need to use a Script Component for this. I did a presentation on this a while back, feel free to download my sample code here: http://www.timmitchell.net/page/Resources.aspx,...

Just FYI, you'll have better responses if you post your questions to a different heading - this is the SSIS forum.

System databases are a core part of the database engine,...