Saving SSIS package connection passwords

Hello All,

I'm new to SQL 2005. I am setting up some SSIS packages which will connect to an Oracle database and copy some tables from it. These packages will then be scheduled to run on a daily basis. Because they will run automatically, it is required that passwords be saved along with the connection string. However, even though the password is saved (and encrypted, I checked the .dtsx in notepad), when I run the package, the connection to Oracle fails. Only if I respecify the password does it run correctly. How can I correctly save this password so that I can schedule automatic execution? Thanks for any info.

If you search this forum for "connection password" you'll get plenty of results. Basically, SSIS does not save passwords in connection strings.

Verify that your package property, ProtectionLevel, is set to EncryptSensitiveWithUserKey. If that doesn't work, then you can put the connection string for the Oracle database in a configuration file, of which you can manually update to contain the password. All of this is posted throughout this forum.|||

Hi,

Thanks for your reply. The thing about that is, that the package is owned by the OS user I use, but the Server Agent runs on another profile (System), so encrypting with a user key will make the Agent unable to execute de package. I wil check out the configuratio file thing, though.

|||Then you can do EncryptSensitiveWithPassword and specify the package password in SQL Agent by altering the dtexec command line parameters.|||I ran into your problem and my solution was to change the CreatorName property of the package to the account that SQL Agent runs under, and I also changed the CreatorComputerName to the name of the production server, then it finally workedsql

Saving space by using nulls?

Say that I have 2 identical tables with the only difference that one table
allows nulls on all of its *numeric* columns and the other one does not.
Now say that I add the same amount of rows to both tables with the only
difference that on the table that does not allow nulls in its numeric
columns I insert numeric values while in the one that does allow nulls I
insert <<Null>> value.
Will both tables use the same storage space or would the table that allows
nulls use less space because I am insetting Null values on it?
Thanks
Same. As of 7.0, space requirement for fixed length column is the same regardless if a column of a
row has null or an actual value.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rene" <nospam@.nospam.com> wrote in message news:%23m6dfC8zFHA.1032@.TK2MSFTNGP12.phx.gbl...
> Say that I have 2 identical tables with the only difference that one table allows nulls on all of
> its *numeric* columns and the other one does not.
> Now say that I add the same amount of rows to both tables with the only difference that on the
> table that does not allow nulls in its numeric columns I insert numeric values while in the one
> that does allow nulls I insert <<Null>> value.
> Will both tables use the same storage space or would the table that allows nulls use less space
> because I am insetting Null values on it?
> Thanks
>
>
|||Thanks Tibor
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eemuGL8zFHA.1968@.TK2MSFTNGP10.phx.gbl...
> Same. As of 7.0, space requirement for fixed length column is the same
> regardless if a column of a row has null or an actual value.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Rene" <nospam@.nospam.com> wrote in message
> news:%23m6dfC8zFHA.1032@.TK2MSFTNGP12.phx.gbl...
>

Saving space by using nulls?

Say that I have 2 identical tables with the only difference that one table
allows nulls on all of its *numeric* columns and the other one does not.
Now say that I add the same amount of rows to both tables with the only
difference that on the table that does not allow nulls in its numeric
columns I insert numeric values while in the one that does allow nulls I
insert <<Null>> value.
Will both tables use the same storage space or would the table that allows
nulls use less space because I am insetting Null values on it?
ThanksSame. As of 7.0, space requirement for fixed length column is the same regardless if a column of a
row has null or an actual value.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rene" <nospam@.nospam.com> wrote in message news:%23m6dfC8zFHA.1032@.TK2MSFTNGP12.phx.gbl...
> Say that I have 2 identical tables with the only difference that one table allows nulls on all of
> its *numeric* columns and the other one does not.
> Now say that I add the same amount of rows to both tables with the only difference that on the
> table that does not allow nulls in its numeric columns I insert numeric values while in the one
> that does allow nulls I insert <<Null>> value.
> Will both tables use the same storage space or would the table that allows nulls use less space
> because I am insetting Null values on it?
> Thanks
>
>|||Thanks Tibor
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eemuGL8zFHA.1968@.TK2MSFTNGP10.phx.gbl...
> Same. As of 7.0, space requirement for fixed length column is the same
> regardless if a column of a row has null or an actual value.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Rene" <nospam@.nospam.com> wrote in message
> news:%23m6dfC8zFHA.1032@.TK2MSFTNGP12.phx.gbl...
>> Say that I have 2 identical tables with the only difference that one
>> table allows nulls on all of its *numeric* columns and the other one does
>> not.
>> Now say that I add the same amount of rows to both tables with the only
>> difference that on the table that does not allow nulls in its numeric
>> columns I insert numeric values while in the one that does allow nulls I
>> insert <<Null>> value.
>> Will both tables use the same storage space or would the table that
>> allows nulls use less space because I am insetting Null values on it?
>> Thanks
>>
>

Saving space by using nulls?

Say that I have 2 identical tables with the only difference that one table
allows nulls on all of its *numeric* columns and the other one does not.
Now say that I add the same amount of rows to both tables with the only
difference that on the table that does not allow nulls in its numeric
columns I insert numeric values while in the one that does allow nulls I
insert <<Null>> value.
Will both tables use the same storage space or would the table that allows
nulls use less space because I am insetting Null values on it?
ThanksSame. As of 7.0, space requirement for fixed length column is the same regar
dless if a column of a
row has null or an actual value.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rene" <nospam@.nospam.com> wrote in message news:%23m6dfC8zFHA.1032@.TK2MSFTNGP12.phx.gbl...[
vbcol=seagreen]
> Say that I have 2 identical tables with the only difference that one table
allows nulls on all of
> its *numeric* columns and the other one does not.
> Now say that I add the same amount of rows to both tables with the only di
fference that on the
> table that does not allow nulls in its numeric columns I insert numeric va
lues while in the one
> that does allow nulls I insert <<Null>> value.
> Will both tables use the same storage space or would the table that allows
nulls use less space
> because I am insetting Null values on it?
> Thanks
>
>[/vbcol]|||Thanks Tibor
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eemuGL8zFHA.1968@.TK2MSFTNGP10.phx.gbl...
> Same. As of 7.0, space requirement for fixed length column is the same
> regardless if a column of a row has null or an actual value.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Rene" <nospam@.nospam.com> wrote in message
> news:%23m6dfC8zFHA.1032@.TK2MSFTNGP12.phx.gbl...
>sql

Saving full-text catalog to different location than default

Hi,
I am writing a database install application that will also create
full-text catalogs on specified data tables. Thanks to help I got
here, this works just fine.
I would also like to store these catalogs to a location different than
default provided by SQL Server. I can retrieve catalog name and
prompt user for a new location so far but how to store it to that
location.
How can I do that?
Thank you,
any help will be appreciated.
_dino_
sp_fulltext_catalog allows you to place it where ever you want. here is a
link describing it.
http://msdn.microsoft.com/library/de...fa-fz_1m07.asp
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dino Buljubasic" <dino@.noplacelikehome.com> wrote in message
news:ha92f1lobmt3c2qit0p7mqa3s5grid4jr1@.4ax.com...
> Hi,
> I am writing a database install application that will also create
> full-text catalogs on specified data tables. Thanks to help I got
> here, this works just fine.
> I would also like to store these catalogs to a location different than
> default provided by SQL Server. I can retrieve catalog name and
> prompt user for a new location so far but how to store it to that
> location.
> How can I do that?
> Thank you,
> any help will be appreciated.
> _dino_
|||Thank you, appreciate the help.
_dino_
On Wed, 3 Aug 2005 17:03:14 -0400, "Hilary Cotter"
<hilary.cotter@.gmail.com> wrote:

>sp_fulltext_catalog allows you to place it where ever you want. here is a
>link describing it.
>http://msdn.microsoft.com/library/de...fa-fz_1m07.asp

saving DTS package to sql server

hi,

I have a "Transfer sql server object task" in SSIS that transfers few tables from one database to another.

The task works fine and the project is saved on my c: drive.

I was trying to save the project on the SQL server and don't know if i am doing somehting wrong?

I have the following selections made:

Package Location: SQL server

Server: ServerName

Authentication Type: Windows

Package path: /TransferTables

Protection Level: Encrypt sensitive data with user key

Now when i hit ok i get the "No description found" error with the following details:

No description found (Microsoft Visual Studio)

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)
at Microsoft.DataTransformationServices.Controls.PackageLocationControl.SavePackage(Package package)
at Microsoft.DataTransformationServices.Design.Controls.PackageSaveCopyForm.PackageSaveCopyForm_FormClosing(Object sender, FormClosingEventArgs e)

Does anyone have a solution to this?

Thanks for any help.

I got past the above error and now i am getting this

Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer(Package pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction.ImportPackage(ImportPackageAsForm dlg)

Any help is appreciated?

|||

As a workaround you can use DTUtil to copy/move a package from the file system to SQL Server.

DTUtil /file fully_qualified_filename /copy sql;pkgname

So: DTUtil /file c:\Packages\MyPkg.dtsx /copy sql;MyPkg

HTH,

Matt

|||

Hi David,

Thanks for the reply.

I finally got the package imported into the sql server.

The problem now is that when i run it remotely from the server machine it works fine but when i run it from my desktop i get the following error:

"The task cannot run on this edition of integration services. it requires a higher level edition"

any ideas?

Thanks

|||

Usually this is because you don't have SSIS installed on the PC in question. You need SSIS installed not just the management tools.

Matt

|||doesn't SSIS get installed as part of the client tools?|||I think you have to install Business Inteligence Management Studio in order to access SSIS packages.|||No, you need to install SSIS from the SSIS option in setup.|||I do have the Business Intelligence Management Studio installed.|||

Hi RookieDBA,

how did you import the files finally, by using Management Studio or with the util? I'm asking because I'm having the same problem and therefore it is very interesting for me to have a solution how to solve this.

Regards,

Jan

|||

I used util. I was not able to import using management studio.

|||I'm having this same problem. Did you ever get a solution?

===================================

Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer(Package pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction.ImportPackage(ImportPackageAsForm dlg)|||Use the dtutil. See reply above from Matt David|||True the dtsutil is a work around. However, the actual probably I found to be corrected by uninstalling the sqltools hotfix(kb918222) and the reinstalling it. Perhaps the hotfix was applied in the wrong order on this machine. http://support.microsoft.com/?id=91822|||

Installing the hotfix had no effect for me. Still got the error, and yes I installed the packages individually to avoid having the install fail.

The problem seems to be with the package itself, as I don't have the same issue with other packages. I tried to recreate the package from scratch, but the second one failed as well. The package is very simple. Two data sources - one ODBC and one SQL, two corresponding connection managers, an execute SQL task and a data flow task with two sub-steps (data reader source and OLE destination).

Actually found a solution to this in another thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=406974&SiteID=1

The short answer is run: regsvr32 msxml3.dll and regsvr32 msxml6.dll

saving DTS package to sql server

hi,

I have a "Transfer sql server object task" in SSIS that transfers few tables from one database to another.

The task works fine and the project is saved on my c: drive.

I was trying to save the project on the SQL server and don't know if i am doing somehting wrong?

I have the following selections made:

Package Location: SQL server

Server: ServerName

Authentication Type: Windows

Package path: /TransferTables

Protection Level: Encrypt sensitive data with user key

Now when i hit ok i get the "No description found" error with the following details:

No description found (Microsoft Visual Studio)

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)
at Microsoft.DataTransformationServices.Controls.PackageLocationControl.SavePackage(Package package)
at Microsoft.DataTransformationServices.Design.Controls.PackageSaveCopyForm.PackageSaveCopyForm_FormClosing(Object sender, FormClosingEventArgs e)

Does anyone have a solution to this?

Thanks for any help.

I got past the above error and now i am getting this

Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer(Package pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction.ImportPackage(ImportPackageAsForm dlg)

Any help is appreciated?

|||

As a workaround you can use DTUtil to copy/move a package from the file system to SQL Server.

DTUtil /file fully_qualified_filename /copy sql;pkgname

So: DTUtil /file c:\Packages\MyPkg.dtsx /copy sql;MyPkg

HTH,

Matt

|||

Hi David,

Thanks for the reply.

I finally got the package imported into the sql server.

The problem now is that when i run it remotely from the server machine it works fine but when i run it from my desktop i get the following error:

"The task cannot run on this edition of integration services. it requires a higher level edition"

any ideas?

Thanks

|||

Usually this is because you don't have SSIS installed on the PC in question. You need SSIS installed not just the management tools.

Matt

|||doesn't SSIS get installed as part of the client tools?|||I think you have to install Business Inteligence Management Studio in order to access SSIS packages.|||No, you need to install SSIS from the SSIS option in setup.|||I do have the Business Intelligence Management Studio installed.|||

Hi RookieDBA,

how did you import the files finally, by using Management Studio or with the util? I'm asking because I'm having the same problem and therefore it is very interesting for me to have a solution how to solve this.

Regards,

Jan

|||

I used util. I was not able to import using management studio.

|||I'm having this same problem. Did you ever get a solution?

===================================

Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer(Package pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction.ImportPackage(ImportPackageAsForm dlg)

|||Use the dtutil. See reply above from Matt David|||True the dtsutil is a work around. However, the actual probably I found to be corrected by uninstalling the sqltools hotfix(kb918222) and the reinstalling it. Perhaps the hotfix was applied in the wrong order on this machine. http://support.microsoft.com/?id=91822
|||

Installing the hotfix had no effect for me. Still got the error, and yes I installed the packages individually to avoid having the install fail.

The problem seems to be with the package itself, as I don't have the same issue with other packages. I tried to recreate the package from scratch, but the second one failed as well. The package is very simple. Two data sources - one ODBC and one SQL, two corresponding connection managers, an execute SQL task and a data flow task with two sub-steps (data reader source and OLE destination).

Actually found a solution to this in another thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=406974&SiteID=1

The short answer is run: regsvr32 msxml3.dll and regsvr32 msxml6.dll

sql

saving DTS package to sql server

hi,

I have a "Transfer sql server object task" in SSIS that transfers few tables from one database to another.

The task works fine and the project is saved on my c: drive.

I was trying to save the project on the SQL server and don't know if i am doing somehting wrong?

I have the following selections made:

Package Location: SQL server

Server: ServerName

Authentication Type: Windows

Package path: /TransferTables

Protection Level: Encrypt sensitive data with user key

Now when i hit ok i get the "No description found" error with the following details:

No description found (Microsoft Visual Studio)

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)
at Microsoft.DataTransformationServices.Controls.PackageLocationControl.SavePackage(Package package)
at Microsoft.DataTransformationServices.Design.Controls.PackageSaveCopyForm.PackageSaveCopyForm_FormClosing(Object sender, FormClosingEventArgs e)

Does anyone have a solution to this?

Thanks for any help.

I got past the above error and now i am getting this

Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer(Package pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction.ImportPackage(ImportPackageAsForm dlg)

Any help is appreciated?

|||

As a workaround you can use DTUtil to copy/move a package from the file system to SQL Server.

DTUtil /file fully_qualified_filename /copy sql;pkgname

So: DTUtil /file c:\Packages\MyPkg.dtsx /copy sql;MyPkg

HTH,

Matt

|||

Hi David,

Thanks for the reply.

I finally got the package imported into the sql server.

The problem now is that when i run it remotely from the server machine it works fine but when i run it from my desktop i get the following error:

"The task cannot run on this edition of integration services. it requires a higher level edition"

any ideas?

Thanks

|||

Usually this is because you don't have SSIS installed on the PC in question. You need SSIS installed not just the management tools.

Matt

|||doesn't SSIS get installed as part of the client tools?|||I think you have to install Business Inteligence Management Studio in order to access SSIS packages.|||No, you need to install SSIS from the SSIS option in setup.|||I do have the Business Intelligence Management Studio installed.|||

Hi RookieDBA,

how did you import the files finally, by using Management Studio or with the util? I'm asking because I'm having the same problem and therefore it is very interesting for me to have a solution how to solve this.

Regards,

Jan

|||

I used util. I was not able to import using management studio.

|||I'm having this same problem. Did you ever get a solution?

===================================

Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer(Package pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction.ImportPackage(ImportPackageAsForm dlg)|||Use the dtutil. See reply above from Matt David|||True the dtsutil is a work around. However, the actual probably I found to be corrected by uninstalling the sqltools hotfix(kb918222) and the reinstalling it. Perhaps the hotfix was applied in the wrong order on this machine. http://support.microsoft.com/?id=91822|||

Installing the hotfix had no effect for me. Still got the error, and yes I installed the packages individually to avoid having the install fail.

The problem seems to be with the package itself, as I don't have the same issue with other packages. I tried to recreate the package from scratch, but the second one failed as well. The package is very simple. Two data sources - one ODBC and one SQL, two corresponding connection managers, an execute SQL task and a data flow task with two sub-steps (data reader source and OLE destination).

Actually found a solution to this in another thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=406974&SiteID=1

The short answer is run: regsvr32 msxml3.dll and regsvr32 msxml6.dll

saving DTS package to sql server

hi,

I have a "Transfer sql server object task" in SSIS that transfers few tables from one database to another.

The task works fine and the project is saved on my c: drive.

I was trying to save the project on the SQL server and don't know if i am doing somehting wrong?

I have the following selections made:

Package Location: SQL server

Server: ServerName

Authentication Type: Windows

Package path: /TransferTables

Protection Level: Encrypt sensitive data with user key

Now when i hit ok i get the "No description found" error with the following details:

No description found (Microsoft Visual Studio)

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)
at Microsoft.DataTransformationServices.Controls.PackageLocationControl.SavePackage(Package package)
at Microsoft.DataTransformationServices.Design.Controls.PackageSaveCopyForm.PackageSaveCopyForm_FormClosing(Object sender, FormClosingEventArgs e)

Does anyone have a solution to this?

Thanks for any help.

I got past the above error and now i am getting this

Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer(Package pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction.ImportPackage(ImportPackageAsForm dlg)

Any help is appreciated?

|||

As a workaround you can use DTUtil to copy/move a package from the file system to SQL Server.

DTUtil /file fully_qualified_filename /copy sql;pkgname

So: DTUtil /file c:\Packages\MyPkg.dtsx /copy sql;MyPkg

HTH,

Matt

|||

Hi David,

Thanks for the reply.

I finally got the package imported into the sql server.

The problem now is that when i run it remotely from the server machine it works fine but when i run it from my desktop i get the following error:

"The task cannot run on this edition of integration services. it requires a higher level edition"

any ideas?

Thanks

|||

Usually this is because you don't have SSIS installed on the PC in question. You need SSIS installed not just the management tools.

Matt

|||doesn't SSIS get installed as part of the client tools?|||I think you have to install Business Inteligence Management Studio in order to access SSIS packages.|||No, you need to install SSIS from the SSIS option in setup.|||I do have the Business Intelligence Management Studio installed.|||

Hi RookieDBA,

how did you import the files finally, by using Management Studio or with the util? I'm asking because I'm having the same problem and therefore it is very interesting for me to have a solution how to solve this.

Regards,

Jan

|||

I used util. I was not able to import using management studio.

|||I'm having this same problem. Did you ever get a solution?

===================================

Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer(Package pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction.ImportPackage(ImportPackageAsForm dlg)|||Use the dtutil. See reply above from Matt David|||True the dtsutil is a work around. However, the actual probably I found to be corrected by uninstalling the sqltools hotfix(kb918222) and the reinstalling it. Perhaps the hotfix was applied in the wrong order on this machine. http://support.microsoft.com/?id=91822|||

Installing the hotfix had no effect for me. Still got the error, and yes I installed the packages individually to avoid having the install fail.

The problem seems to be with the package itself, as I don't have the same issue with other packages. I tried to recreate the package from scratch, but the second one failed as well. The package is very simple. Two data sources - one ODBC and one SQL, two corresponding connection managers, an execute SQL task and a data flow task with two sub-steps (data reader source and OLE destination).

Actually found a solution to this in another thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=406974&SiteID=1

The short answer is run: regsvr32 msxml3.dll and regsvr32 msxml6.dll

saving changes made to database

I have an application that connects and edits a database's tables.

My question is, what is the best way to save who did what changes to
this database? I need to be able to display this in the application.
The best way I have thought of so far is, to create a new table with
'user', 'date', 'table_name', 'primary_key', 'old field_value' and
'new_field_value' fields. Then I can save which table row had been
changed, by which user and on which date.

I'm sure that there is a way to do this in SQL Server, but I'm not
sure how.

Any help would be appriciated.

JagdipHi

There is a simple auditing example in Create Trigger topic in Books online,
I would always choose to keep the processing in the trigger to a minimum and
then process the information later as a separate process or when it is
displayed.

For an off the shelf solution you could look at the Lumigent products:
http://www.lumigent.com/Products/

John

"Jagdip Singh Ajimal" <jsa1981@.hotmail.com> wrote in message
news:c84eb1b0.0410010403.a28c3c7@.posting.google.co m...
> I have an application that connects and edits a database's tables.
> My question is, what is the best way to save who did what changes to
> this database? I need to be able to display this in the application.
> The best way I have thought of so far is, to create a new table with
> 'user', 'date', 'table_name', 'primary_key', 'old field_value' and
> 'new_field_value' fields. Then I can save which table row had been
> changed, by which user and on which date.
> I'm sure that there is a way to do this in SQL Server, but I'm not
> sure how.
> Any help would be appriciated.
> Jagdip

Save/Copy column mappings in DTS?

Is it possible to save column mapping definitions from a Transform Data Task? The practical use is I have four tables with very similar layouts of which 200 or so columns are identical. I have various front and back office applications that require local copies of this data in various formats. It is EXTREMELY tedious to remap all of the columns for each Transform Data Task required on these applications.

Is there a way to store all of the column mapping def's and import them into a new transform data task?if you are using SSIS, the task itself is an xml file so you could just edit it directly... :)

EDIT: did I say task? I meant the package is an xml file.|||Save the package in Visual basic File then edit it.
And you can re-create the package from the Visual basic File.|||I should have mentioned this is sql 2k I suppose. I haven't toyed with saving packages as vb scripts yet, I'll give that a go and see what sort of damage I can do.

save XML in a table

Im not talking about storing the attributes of the elements of an XML file
into different columns of tables(s) but saving the entire XML into a single
row and column as a blob ?
What would be the pros and cons of doing it as such ?In SQL Server 2005, there is an XML datatype, which handles this quite well.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"Hassan" <Hassan@.hotmail.com> wrote in message
news:uLY662iJGHA.516@.TK2MSFTNGP15.phx.gbl...
Im not talking about storing the attributes of the elements of an XML file
into different columns of tables(s) but saving the entire XML into a single
row and column as a blob ?
What would be the pros and cons of doing it as such ?|||But curious about SQL 2000 ?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:eiU9scmJGHA.648@.TK2MSFTNGP14.phx.gbl...
> In SQL Server 2005, there is an XML datatype, which handles this quite
> well.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:uLY662iJGHA.516@.TK2MSFTNGP15.phx.gbl...
> Im not talking about storing the attributes of the elements of an XML file
> into different columns of tables(s) but saving the entire XML into a
> single
> row and column as a blob ?
> What would be the pros and cons of doing it as such ?
>
>|||Check "XML best practices" in BOL.
In short, when you don't need xml data type you need blob. And when you need
identical copy of the XML string, such as legal document, you need blob. I
mean varchar(max) by blob.
Pohwan Han. Seoul. Have a nice day.
"Hassan" <Hassan@.hotmail.com> wrote in message
news:uLY662iJGHA.516@.TK2MSFTNGP15.phx.gbl...
> Im not talking about storing the attributes of the elements of an XML file
> into different columns of tables(s) but saving the entire XML into a
> single row and column as a blob ?
> What would be the pros and cons of doing it as such ?
>|||Some of the problems:
-How will you search for data in the column/row within the XML?
-If the XML document is 50MB, how will you insert the data? OPENXML will
require you to load the document into a variable, using a huge amount of
resources.
-In a table with 50,000 rows, how do you identify each XML document?
"Han" wrote:

> Check "XML best practices" in BOL.
> In short, when you don't need xml data type you need blob. And when you ne
ed
> identical copy of the XML string, such as legal document, you need blob. I
> mean varchar(max) by blob.
> --
> Pohwan Han. Seoul. Have a nice day.
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:uLY662iJGHA.516@.TK2MSFTNGP15.phx.gbl...
>|||If you want to do any of that, I really recommend to upgrade to SQL Server
2005. SQL Server 2000 was not designed for managing XML documents as a unit
but for enabling relational integration into XML.
Best regards
Michael
"Sal Young" <SalYoung@.discussions.microsoft.com> wrote in message
news:3427C6A2-CD47-486F-A21A-646CAB18662D@.microsoft.com...
> Some of the problems:
> -How will you search for data in the column/row within the XML?
> -If the XML document is 50MB, how will you insert the data? OPENXML will
> require you to load the document into a variable, using a huge amount of
> resources.
> -In a table with 50,000 rows, how do you identify each XML document?
> "Han" wrote:
>sql

save XML in a table

Im not talking about storing the attributes of the elements of an XML file
into different columns of tables(s) but saving the entire XML into a single
row and column as a blob ?
What would be the pros and cons of doing it as such ?
In SQL Server 2005, there is an XML datatype, which handles this quite well.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"Hassan" <Hassan@.hotmail.com> wrote in message
news:uLY662iJGHA.516@.TK2MSFTNGP15.phx.gbl...
Im not talking about storing the attributes of the elements of an XML file
into different columns of tables(s) but saving the entire XML into a single
row and column as a blob ?
What would be the pros and cons of doing it as such ?
|||But curious about SQL 2000 ?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:eiU9scmJGHA.648@.TK2MSFTNGP14.phx.gbl...
> In SQL Server 2005, there is an XML datatype, which handles this quite
> well.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:uLY662iJGHA.516@.TK2MSFTNGP15.phx.gbl...
> Im not talking about storing the attributes of the elements of an XML file
> into different columns of tables(s) but saving the entire XML into a
> single
> row and column as a blob ?
> What would be the pros and cons of doing it as such ?
>
>
|||Check "XML best practices" in BOL.
In short, when you don't need xml data type you need blob. And when you need
identical copy of the XML string, such as legal document, you need blob. I
mean varchar(max) by blob.
Pohwan Han. Seoul. Have a nice day.
"Hassan" <Hassan@.hotmail.com> wrote in message
news:uLY662iJGHA.516@.TK2MSFTNGP15.phx.gbl...
> Im not talking about storing the attributes of the elements of an XML file
> into different columns of tables(s) but saving the entire XML into a
> single row and column as a blob ?
> What would be the pros and cons of doing it as such ?
>
|||Some of the problems:
-How will you search for data in the column/row within the XML?
-If the XML document is 50MB, how will you insert the data? OPENXML will
require you to load the document into a variable, using a huge amount of
resources.
-In a table with 50,000 rows, how do you identify each XML document?
"Han" wrote:

> Check "XML best practices" in BOL.
> In short, when you don't need xml data type you need blob. And when you need
> identical copy of the XML string, such as legal document, you need blob. I
> mean varchar(max) by blob.
> --
> Pohwan Han. Seoul. Have a nice day.
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:uLY662iJGHA.516@.TK2MSFTNGP15.phx.gbl...
>
|||If you want to do any of that, I really recommend to upgrade to SQL Server
2005. SQL Server 2000 was not designed for managing XML documents as a unit
but for enabling relational integration into XML.
Best regards
Michael
"Sal Young" <SalYoung@.discussions.microsoft.com> wrote in message
news:3427C6A2-CD47-486F-A21A-646CAB18662D@.microsoft.com...[vbcol=seagreen]
> Some of the problems:
> -How will you search for data in the column/row within the XML?
> -If the XML document is 50MB, how will you insert the data? OPENXML will
> require you to load the document into a variable, using a huge amount of
> resources.
> -In a table with 50,000 rows, how do you identify each XML document?
> "Han" wrote:

Save custom settings in SQL Server Management Studio Express

I use SQL Server Management Studio Express to work in several databases. What gets annoying, is that the databases I work in have 30+ tables in them, only 5-10 of which I actually work with. Then there's the stored procedures I have to sort through to find the ones that I need and so on. I set filters so that I see only what is applicable to me, but I hate having to set those filters every time I start Management Studio back up. Is there a way to save my settings so that it opens the same way every time? I've looked around and can't find an answer to this.

Thanks!

Hi Kevin,

Sorry, but the filters cannot be saved in SQL Server Management Studio. The filter is used temporarily for us to get objects we need.

You may create the objects under some special schema and sort by schema, so that you can find them more quickly.

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!

SAP r/3

Does anybody have any knowledge of a driver For SAP database ? to extract cluster tables from SAP to MS Sql server.There is a SAP .net connector but I think that is only for netweaver..could be wrong though.

You should ask your question at sdn.sap.com if you don't get a better answer here.

HTH