when I try to expand the MSDB folder of SSIS in SQL Management
Studio I get the following error:
Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)

I have a problem with the connections in the packages.
Some people write a package on the server with Windows Authentication in the
connection. I copy the package on my computer and I wait 5 minutes when
Visual Studio open the package beaucause it test all connections and go in

I need to estimate the effort required in writing some SSIS packages.
Could anyone provide some pointers to the various factors (E.g. number of
tables, source, etc.) which influence the effort estimate for SSIS packages?
Thanks in advance.

I am using a SQL table for my SSIS Configurations setttings.  
While in development; it would be useful to display these settings when I execute the package.  I have done this in the past with ActiveX scripting - but am unsure how to expose the values the Package Configuration ...

We are developing and application using SQL Server 2005 and would like to use
Integration Services for an import/export capability between SQL Server and
Microsoft Access.  The question comes into play with the deployment of the
application.  We would like to deploy the ...

SQL Server Standard edition SP1 running on Windows server 2003 R2 EE SP1
I have double click the job, highlight steps, double click step name, Click
the Logging tab to add log providers. Select a log provider in the Log
Provider list and then type the connection string.

I'm using SSAS to build a cube.  Within my data source view (DSV), I have some tables that are used over and over (forget the term).  
For example I have a Worker table that is joined on by a Fact table many times.  Within the Fact table are columns such as CreatedByWorker, ...

In SSAS I did some renaming of my Objects and I get an error I can't seem to work around.  I renamed my cube from 'DA Data Mart Dev' to something else - but the solution seems to be looking for the old name.  VSS appears to have renamed the cube ok - but there is no copy of the ...

I have a need in Integration Services which I haven't been able to
find answers for. I have data in a staging table. Some minor
manipulation is performed and those records are inserted into the
primary table via an Execute SQL Task. The SQL of the task has the

I have VS2005 Prof with MSSQL 2005 Dev Ed. All services starts except SSIS.
When I try to start it then I have error message:
The request failed or the service did not respond in timely fashion.
How to avoid this situation?

I am migrating DTS packages for a client of mine to SSIS. This should have
been pretty straight forward as I have done this numerous times before in
the past of 3 years,. However, my client has new  Itanium 64Bit machines.
I read the "Integration Services Considerations on 64-bit ...

I've got a package with 2 dataflows each encased in a sequence.  The
sequence is set to require a transaction and everything downstream
supports transactions.  My source is DB2 on AS/400 and the destination
is SQL 2005.  I've configured the MS DTC to allow inbound and out-

How does the Inferred Member Updates work? There is a tickbox to enable
support and 2 options. The second option is to use a boolean column to
indicate if this is an inferred member. Why is this needed. Surely the
"Insert Destination" OLEDB command will add in new rows anyway? Is ...

I have a table, with records something like this:
id  data
1   a
1   b

I still can't use temporary tables in stored procedures launched by OLE DB
Source in data flow task.
I have used delay validation = TRUE and retainsameconnection = TRUE settings
to no avail.