Re: Confused switching from 2000 DTS to 2005 SSIS

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On 15 Ott, 04:13, Todd C <To...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hello Nathaniel:

I haven't done an import/export wizard in a while so don't remember where it
saves the package. BUT, knowing the file type is ".dtsx" you could do a
desktop search of the files on the machine to find that type.

In the Business Intelligence Develepment Studio, they are store under My
Documents/Visual Studio 2005/Projects...

HTH
--
Todd C

"Nathaniel" wrote:
I am trying to recreate some fairly simple data exports that I had in 2000
DTS packages. I created them by using the data export wizard and then
selecting the "Save DTS Package" option at the end. Then I could re-open them
in the DTS designer to make modifications, copy and paste them to string
together, etc.

I just created my first export in Management Studio 2005 and the export data
wizard is mostly the same. However, I have no idea how to find the SSIS
"package" that I just saved. I'm still learning my way around the IDE and any
help would be appreciated. Thanks in advance.

Hi,
if you're using Management Studio (right-click on DB icon then Task
then Export, for istance) then after choosing Source, target and which
tables to export you should also have some options like: execute
immediately, Save SSIS package. This second one is folloew by two
alternative options: File System (then browse your profile's folders)
or SQLServer (then it's saved in msdb, you can see it by connecting to
Integration Services from Management Studio).

M.
.

Relevant Pages

  • Re: Trying to get a SSIS Import wizard package to actually schedule and work.
    ... It allows you to save it as did DTS wizard. ... This is inconsistent with SQL Server 2000 DTS. ... there are some *.tmp files that will stored under ... necessary during the execution of the package. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS to SSIS lost functionality
    ... Try this with both a wizard in DTS and a wizard in SSIS: ... Crate a package that exports data from a SQL table and dumps into an Excel ...
    (microsoft.public.sqlserver.dts)
  • Re: >> SSIS Error Report
    ... errors and add one of these destination controls to the error branch ... of each SSIS control. ... the import wizard, not developing the packages yourself .. ... One thing you could try is to save the package created by the wizard ...
    (microsoft.public.sqlserver.dts)
  • Re: >> SSIS Error Report
    ... errors and add one of these destination controls to the error branch ... of each SSIS control. ... the import wizard, not developing the packages yourself .. ... One thing you could try is to save the package created by the wizard ...
    (microsoft.public.sqlserver.dts)
  • Re: Sql Server 2005 Import Wizard - keep NULLS
    ... I tested this option (saving the package in the server, ... and executing the modified package) and it works well: it keeps the nulls. ... The SQL 2000 import wizard will insert null in these cases. ...
    (microsoft.public.sqlserver.dts)