[dba-SQLServer] Importing From Access to SQL2005

David Emerson newsgrps at dalyn.co.nz
Mon Feb 2 10:45:03 CST 2009


Thanks Mark.  Not there.

At 3/02/2009, you wrote:

>Everytime I lose a project/sql statement or 
>anything in SQL Server...I always find it in:
>
>"C:\Documents and Settings\'yourID'\My 
>Documents\SQL Server Management Studio\Projects"
>
>Good luck,
>
>Mark
>
>----------------------------------------
> > Date: Mon, 2 Feb 2009 18:24:02 +1300
> > To: dba-sqlserver at databaseadvisors.com
> > From: newsgrps at dalyn.co.nz
> > Subject: 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
> >
>_________________________________________________________________
>Windows Live™: E-mail. Chat. Share. Get more ways to connect.
>http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t2_allup_explore_012009
>_______________________________________________
>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