Is there a tutorial on the easiest way to export an SQL Server database's
tables into and Access database (all tables without having to do them one at
a time) in a package that runs daily?
Thanks.

I'm doing some database maintenance by erasing DTSs and jobs that are needed
anymore.
I've noticed that there are jobs that don't have a corresponding DTS.
Four jobs called TSQL_JOB_4 - TSQL_JOB_7 do not have corresponding DTS. This

I want to move an Axapta database located on an Oracle databaseserver to a
Microsoft SQL 2005 server.
I would like to avoid writing an individual dataflow transformation for each
table and field in the database.

I'm importing a CSV file into a database. The file includes a couple
of date columns. I've added a Data Conversion step in my Data Flow to
convert those columns. Unfortunately, SSIS does something which I
consider to be nothing short of horrible...

I have an “Execute SQL Task” object in my SQL 2005 Integration Services
Project.
The relative properties are:
ResultSet                SingleRow

I have a sql server 2000 job that is just doing an execution of a DTS pkg.  
When you look at the syntax in the step of the job I see something like:
DTSRun /~ZO4858C301ABE2
The problem is, my DTS packages are not named in any uniform way with the

Is there (on internet) an official reference for the syntax to use trying to
query data from an excel 2003 database in a DTS package ? here are the
details:
We use excel 2003 sp3, sql server 2000 sp4, mdac 2.8 sp1

hi experts,
i am trying to look for answer on deploying SSIS with all connections string
configuration into a SQL Database.
May i know wat & how is the interaction of SSIS n the Configuration Database?

I have a SSIS package
In my source "data flow" task I have a stored procedure (sp_GetTrafficData)
which gets the data and populates the table in the destination task.
The stored procedure sp_GetTrafficData executes another stored procedure the

Is there anyway to set the DataRowsToSkip property at runtime?  I've tried
using an expression but it just gets ignored.  Any suggestions are much
appreciated.

I am trying to pass a value from a stored proc output variable to a user
variable in SSIS. When I define the variable as integer in both SSIS and the
stored proc, every thing is fine, however, it gives me a data type mismatch
error when I declare the variable as varchar in stored ...

I've created simple SSIS package based on:
http://www.sqlservercentral.com/articles/Analysis+Services/63382/
It works great from Business Intelligence Studio,
but doesn't work from SQL Agent Job

I've got > 300 very complicated SSIS packages which execute TSQL and stored
procedures.  SSIS Packages are executed by jobs and some are executed
manually.  At various times I have issues with executing spids and need to
hunt down offending code.  I can get to the TSQL command ...

I have been having a hell of a time with running a dtsx package on my
SQL server 2005. I designed the package on a development machine and
through Visual studio it runs fine. I then imported the package to my
SQL server Integration services. if I right click on the package and

I have installed Microsoft OLE DB Provider for DB2.
I have a problem with string parameters when updating records on AS400/DB2
when using OLE DB Command component in SSIS.
I have some records stored in MSSQL server datatable, for each row in this