[dba-SQLServer] Importing From Access to SQL2005

Mark A Matte markamatte at hotmail.com
Mon Feb 2 09:07:56 CST 2009


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



More information about the dba-SQLServer mailing list