Saving a package into a folder in MSDB

Hi

I am trying to load a ssis package into a folder (lets say SSIS packages) that I created in MSDB but its geeting saved in the root (MSDB) not into the SSIS packages folder...I am doing this thru C#...

Have you tried using the Application.SaveToSqlServerAs method? The 3rd parameter is the package path and there you can specify the "\folder\folder1....\packageName" format for your package.

More info about Application.SaveToSqlServerAs can be found at http://msdn2.microsoft.com/ko-kr/library/microsoft.sqlserver.dts.runtime.application.savetosqlserveras.aspx

HTH,
Ovidiu

|||Thanx Ovidiu... I also checked that before and now its working fine...

Save and load data with schema in MSDE

Hi,

How can I save and load data with schema in MSDE in the quickly way? I need to do this in 5-10 second for 5 millions of rows.

Thank's
Alexei

Please take a look at the BCP command-line utility in Books Online. This allows you to export/import large amounts of data. There are also TSQL versions of the BCP command but only for the insert portion. See BULK INSERT topic for more details.|||

Hi,

It's nice but it works slowly. When I put 1,5 millions of rows it takes 40 seconds and it's it too much.

Thank's
Alexei

|||

Please take a look at the link below for some tips onhow to optimize bulk load:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx

You also realize that the bulk insert will only be as fast as your disk system. It is mostly an I/O bound operation.

Save / load default values for parameters

I have a report with several parameters, and I want to load default values
from a table (this is no problem). But if a user change the default value, I
want this new one to be stored in the same table, so that when the user wants
to run the report later on, the last used default value shows up.
For example: Is there a way to hook an event to the 'View Report'-button
that would run an SQL to do this for me?This is not supported in the current viewer. You would have to write your
own viewer to accomplish this.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"TryM" <TryM@.discussions.microsoft.com> wrote in message
news:943046C4-D681-4F20-BF81-E5CFA8429828@.microsoft.com...
> I have a report with several parameters, and I want to load default values
> from a table (this is no problem). But if a user change the default
value, I
> want this new one to be stored in the same table, so that when the user
wants
> to run the report later on, the last used default value shows up.
> For example: Is there a way to hook an event to the 'View Report'-button
> that would run an SQL to do this for me?
>