[dba-SQLServer] Importing From Access to SQL2005

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