[dba-SQLServer] Importing From Access to SQL2005

David Emerson newsgrps at dalyn.co.nz
Mon Feb 2 11:14:25 CST 2009


Thanks Asger,

The package was saved in a different location.  I 
have moved it to the folder below and it now appears in Integrated services.

My next problem - How can I open it to edit 
it?  If I right click on it I get a number of 
options including Run Package, but none to open it for editing.

David

At 2/02/2009, you wrote:
>An SSIS package can be stored in two different locations:
>1) SQL Server. When stored here the package exists in the system table
>msdb.dbo.sysdtspackages90 (the content of the package is stored in a column
>named packagedata). And when stored here you can see it in Management Studio
>connecting to Integration Services in the folder Stored Packages | MSDB.
>2) File System. When stored here the package only exists in the file system,
>not in msdb.dbo.sysdtspackages90. You may be able to see a file system
>package in Management Studio connecting to Integration Services in the
>folder Stored Packages | File System. But this folder only shows packages
>stored in the disk-folder for SSIS packages, i.e. C:\Program Files\Microsoft
>SQL Server\90\DTS\Packages\
>As you don't see your package in Stored Packages in Integration Services I
>suppose it's saved to the file system in a folder other than said
>disk-folder for SSIS packages. You then have manually to browse your disk
>for it (dir \*.dtsx /s).
>If you find the package and if you want it to show up in Integration
>Services in the folder Stores Packages | File System you can move or copy it
>to said disk-folder for SSIS packages, or you can import it right-clicking
>the File System folder in Integration Services and choosing Import
>Package...
>
>Asger
>
>-----Oprindelig meddelelse-----
>Fra: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af David
>Emerson
>Sendt: 2. februar 2009 06:24
>Til: Discussion concerning MS SQL Server
>Emne: Re: [dba-SQLServer] Importing From Access to SQL2005
>
>OK - Finally found this and had to change the
>configuration setting because I had SQL2000 also
>running on the same computer.  (Error about
>Encryption not supported yada yada yada.
>
>But I still cant find the package in any of the
>folders.  I know I didn't delete it.
>
>David
>
>At 2/02/2009, you wrote:
> >In SQL Server Management Studio connect to Integration Services, then
>expand
> >the folder Stored Packages.
> >
> >Asger
> >
> >-----Oprindelig meddelelse-----
> >Fra: dba-sqlserver-bounces at databaseadvisors.com
> >[mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af David
> >Emerson
> >Sendt: 1. februar 2009 18:28
> >Til: dba-SQLServer at databaseadvisors.com
> >Emne: [dba-SQLServer] Importing From Access to SQL2005
> >
> >Group,
> >
> >This is frustrating.  I have SQL 2005 installed (I believe it is the
> >full version and not Enterprise).  About a month ago I created the
> >equivalent of a data transformation package to copy data from an
> >Access database into some SQL tables.
> >
> >Now when I try to find where the package is in SQL Server Management
> >studio I can't find where packages are stored.
> >
> >Can anyone please give me some pointers as to where they should appear?
> >
> >_______________________________________________
> >dba-SQLServer mailing list
> >dba-SQLServer at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> >http://www.databaseadvisors.com
> >
> >
> >
> >_______________________________________________
> >dba-SQLServer mailing list
> >dba-SQLServer at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> >http://www.databaseadvisors.com
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com





More information about the dba-SQLServer mailing list