Communication between tasks in an SSIS Package

Hi,
I have a Flat File Source and I want to retrieve few properties of it in an Script Component. How do I?

Also, How could I make the file path of Flat File Source or Connection manager dynamic or configurable through some file ?

any input is appreciated.

Fahad

Fahad349 wrote:

Hi,
Also, How could I make the file path of Flat File Source or Connection manager dynamic or configurable through some file ?

Fahad

Look at package configurations. The forum search will be your friend.

Commit Interval in OLE DB Driver

Hi,

I am trying to develop a custom destination component. Is there a way to enable transaction / commit interval in OLE DB drivers?

Thanks,

Vipul

I would say this has to be built into the OLE-DB provider itself. You should then be able to set the value, and would expect it to be a documented property of the provider.

Saying that this is a feature I associate with bulk interfaces, which are not OLE-DB providers themselves, so is it a feature of the OLE-DB specification?

Command TimeOut

Hi,

i've a ASP application builds SQL for a report component; report execution get an error about command timeout, since i can't set it (i pass only query and connection to this component) is there a default generic option (for the SqlServer instance) that permits to me to increase this value?

Thanks : :Dyou need check your sql script: how long does it execute in query analyzer and how many records will return.
if the time is spending on join or you get a large number of records, you need use stored prcoedure to speed up.

command line uninstall of sql express 2005

Another developer is writing the install/uninstall for our app and we're not
sure about the best way to uninstall the database component when the app is
uninstalled. Basically our app installs sql express 2005 ( + other .net stuff
) during install using the command line options and that works great. When it
comes to uninstall we have only one option at the moment - have the user go
to the control panel and manually uninstall the db. Is there an automated way
to remove the db from a machine or a way to issue a batchfile command w/
params? The user doesn't need to maintain this special db instance so want to
remove it automatically.
thanks,
Paul.
hi Paul,
paul wrote:
> Another developer is writing the install/uninstall for our app and
> we're not sure about the best way to uninstall the database component
> when the app is uninstalled. Basically our app installs sql express
> 2005 ( + other .net stuff ) during install using the command line
> options and that works great. When it comes to uninstall we have only
> one option at the moment - have the user go to the control panel and
> manually uninstall the db. Is there an automated way to remove the db
> from a machine or a way to issue a batchfile command w/ params? The
> user doesn't need to maintain this special db instance so want to
> remove it automatically.
> thanks,
> Paul.
http://msdn2.microsoft.com/en-us/lib...installscripts
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply