Few things to try - when you have a ConnectionManager window open, enter the correct password info, hit "Test Connection" to verify it works, check the "Save my passowrd" box,...

I initially went down a dev path where I thought I was going to use Sql Server based configurations but I quickly found out that there is little documentation.  Makes...

In BI Studio, you have a project which is a collection of packages (and data sources and data views).  Once you deploy those packages to a server or file system,...

I've answered most of my own questions - thru trial and error.  Thought I'd post the details for anyone who's interested.

Environment Variables for Configuration

Be careful how and where you launch...

JKSQL - Here's one option for you.  Create a Deployment Utility (see BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/354322a4-ae8c-4d92-8e71-42d29dbd0614.htm).  Basically, in BI Studio you go into the properties for the project.  Do this by right-clicking...

More on this...

I just noticed that a stored procedure is being created, sp_dts_addlogentry().  However, it is being created under the dbo schema.  So, I have this:

• dbo.sp_dts_addlogentry()
• MYSCHEMA.sysdtslog90

When the sp is executed,...

I pretty sure that Sql Server 2005 Express doesn't come with SSIS support.  Check out the version feature comparison - http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

I can't get the import/export wizard to duplicate that functionality.  I get primary key violations no matter what mapping options I choose. If I'm missing something, please let me know.

Jamie -...

Thanks for the info Kathi.

I'm not 100% clear on what you are trying to do but I might look at the script component.  You have to have a little VB.NET familiarity but that component...

I have a package property called ProtectionLevel and it's set to EncryptSensitiveWithUserKey.

Maybe I should start a new thread, but you (KH) are knowledgeable about SSIS so I'll ask here.  Where's the best...

In the package properties, I do not have any option "DontSaveSensitive".  My VS version info is below.

Secondly, I appreciate your help but I'm not an idiot.  I understand that beta software...

Do you mean "RemovePasswords"?  That setting is in Project's property pages.  I have that set to false.  Just to go back to the problem, I was working all day in...

Yeah, the CTP download from MS has BI Studio.  During the install make sure you install everything related to Integration Services and development tools.

One of the readme's says that you...

How about this:

Create a new job.  The first step you execute your INSERT statement.  The second step you call SP_START_JOB() to execute your main Job. And the third step is...