[dba-SQLServer] Importing From Access to SQL2005

Ah, that rings a bell.  That would also explain 
why the file was in a Visual Studio folder. <:-|

Thanks for the help.

David

At 3/02/2009, you wrote:
>You can't edit the package in Management Studio. You have to use Visual
>Studio for that.
>
>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 18:14
>Til: Discussion concerning MS SQL Server
>Emne: Re: [dba-SQLServer] Importing From Access to SQL2005
>
>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
>
>
>_______________________________________________
>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