I see it now. It is in the 'System Tables' folder in the database it should be in.

Thanks!

🙂

Rock, thanks for the information. You'll see that there is no ability to specify the FTP connection's password using the expression builder. (They don't make the password property...

Hey Rock,

I finally got it working. I was getting the "password was not allowed" error until I modified a script task that appears before the FTP task. The...

Hey Rock,

Thanks for the reply. You've helped me identify the problem is related to permissions. I have confirmed this by:

1. logging into the server that I'm trying to...

I think frustrated SSIS developers should swarm on Microsoft's HQ with lit torches and sharp knives and demand to know why they have made it damn near impossible to use...

I have added an "if" statement to prevent execution of Task B unless the desired condition is met. This enables me not to use branching.

Still, it is frustrating that...

This is strange...I deleted the precedence constraint that leaves task A and goes directly to task C. Then I ran the package under the condition that it should go...

Rock, in my last post I admitted that there was a second variable named Package_ID that I had not seen. Your post helped me recognize that fact.

thanks!

Uh, never mind my last post. Rock, you rock yet again.

I didn't see it; but there was another variable named "Package_ID" in my list. I removed it...

Here's a bizarre epilogue to my last post.

I can get a package-wide variable of type string named "Package_ID_str" to retain a value in a second task after the value has...

Rock, you Rock!

I created a test similiar to what you're describing using a package-wide variable named WriteVariable of type string. I added two tasks at the top of my...

Well, two days later I still have NO IDEA how to set and read values in a variable that has package-wide scope. Thank you Microsoft for making it SO...

Well, the reason that execution never enters my loop (described in the first post above) is because I needed the "lockforread" method to be executed prior to it. This...

I'm designing the package in BIDS and running it on a SQL Server. In a couple of script tasks, I'm trying to eliminate global variables and use a package-wide...

Thanks for the reply. I actually now have the XML file working:

http://www.sqlservercentral.com/Forums/Topic1312110-364-1.aspx?Update=1

There were two questions I asked at the top of this thread. One has been...