I have a SQL 2005 SSIS "package" that is running as a job nightly.  We would
like to run the package through Query Analyzer on occassion, rather than
having to wait for the job to run at night.
What would be the query-building "syntax" that would be needed?  Below is

I have a situation where I need to copy data from one server to another, but
instead of copying all of the data, I need to create new GUIDs for the
primary keys
and ensure the foreign keys are updated with the new GUID created.

For the first time, I used the SQL 2005 DTS Migration Wizard to move two SQL
2000 DTS packages to 2005.  It worked.
When I could not find the two packages, I looked in the Business
Intelligence Development Studio and found them in SSIS.  The only thing I

Hello to everybody !
i've a big big problem !
i've a SSIS 2008 Project with as data source a AS/400 DB2 database, my
destination is a SQLServer 2008 database,

Hi NG,
I am quite new to the integration services.
I have a query, which gives as a result all accounts with negative balance.
If  there are any lines, the result sohlud be sent  by email to an

I am loading a dimension, for the source data I group on 1 million records to
ensure I get unique ids for the dimension load.
Now when I do a straight query to a ole db destination it works fine. When I
do the same query and pass it to the slowly changing dimension transform sql

Is it possible to use a variable for the SQL command text of an ADO.NET
source? It's against an ODBC source
How?
I have to run the same query over 1000 times when the only change is a

Will SSIS packages developed using Visual Studio 2008 be able to be
installed on SQL 2005 machines? We are currently in a phased environment
where we are testing SQL 2008 in our DEV labs but our production environment
is still on 2005. So if we develop packages in VS2008 can they ...

I receive a file each morning and I am importing this flat file data into a
SQL table using SSIS.  It now runs daily importing the data. On very rare
occasions one currency field has the word "NONE" in it. The job errors, so I
find the offend blurb and rerun the job. It happens ...

I am a newbie to SSIS 2008. Has some knowledge but not that deep.
I need a solution, please guide.
Scenario:
Col named "Region" has some values "MUM","PUN","CHE","GBR",etc. I want

SQL 2005
I have an SSIS package that calls a 32-bit exe using the Execute Process
Task.  The 32-bit app is an in-house app that downloads a file from a ftp
site, and then unzips the file using shell32.dll.  When I run it

Hi Experts,
I'm trying ot read the error output from Ole DB Destination component.
using Script component. The problem is when I'm trying to read the
columns from PipelineBuffer the order of columns is not as what I

Hi Experts
I’ve just starting using SSIS to copy some tables from an Oracle database
into SQL Server. The package works ok, however, is there a way to report that
the record counts are the same for both databases?

I have SQL Server 2005 workgroup.  It allows me to install SSIS, but when I
do, there is no integration services service, so I cannot connect to it.  I
uninstalled SSIS, and reinstalled, but still not sevice.  I'm not sure if
this functionality is included in Workgroup or not.  ...

We have many SSIS Packages. All the connections/filepaths are
configured/stored in SQL Table (Configuration.dbo.SSISConfigurations). We
have an XML dtsConfig file called "Configurationfile.dtsConfig" to store the
connection information for this SSISConfigurations table (which ...