Can You Help With DTS Pakage?

Nov 2, 2005

Hi,

In our travelinsure1 database, I used DTS to create a package which needs to run on a daily base.
The major task is import data from a text file to a database (CMC_test) table tis_StudyUSA_dataEase_test.
But before I do the import, I need to flush the data in tis_StudyUSA_dataEase_test.

So I need to execute" Delete from tis_StudyUSA_dataEase_test" then the import.
But I just don't know how to set up in DTS package to let this statement run first, not after the import.
Otherwise it will just have empty table.

I just start to learn how to use DTS. Any clue will be very helpful.

Betty

View 8 Replies


ADVERTISEMENT

Pakage Running In Sql Server 2005

Aug 2, 2007

hi friends,

i created the one package for import the data from excel to server 2005

in intellegence services i add the package after deploy

if we run the package (by giving the connection working fine)


BUT I WANT TO RUN THE PACKAGE BY DAILY AUTOMATICALLY(just like a scheduler)


is it possible if possible please give me the coding for auto run a packages

regards
koti

View 1 Replies View Related

Execute Pakage - Configurations Files

Nov 16, 2007



Hi,

I added a configuration file to my pakage for changing the connections strin, but whe I execute the deployed package and in the Execute pakage utility I add the .dtsconfig file and then execute it it never takes the connection string stored in the configuration file. Mi configuration file is:


<?xml version="1.0"?>

<DTSConfiguration>

<DTSConfigurationHeading>

<DTSConfigurationFileInfo GeneratedBy="domuser" GeneratedFromPackageName="PCKG_BH_AFFILLIATIONCONTRACT_INVOICE_DETAIL" GeneratedFromPackageID="{52B4012E-30A7-46E0-B147-EE40DC1B7228}" GeneratedDate="11/15/2007 7:21:09 PM"/>

</DTSConfigurationHeading>

<Configuration ConfiguredType="Property" Path="Package.Connections[BDTEAMSERVER.BeyondHealthCharge].Properties[ConnectionString]" ValueType="String">

<ConfiguredValue>Data Source=BDTEAMSERVER;Initial Catalog=BDTEAMSERVER.BeyondHealthDB;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;</ConfiguredValue>

</Configuration>

<Configuration ConfiguredType="Property" Path="Package.Connections[BDTEAMSERVER.BeyondHealthCharge].Properties[Description]" ValueType="String">

<ConfiguredValue></ConfiguredValue>

</Configuration>

<Configuration ConfiguredType="Property" Path="Package.Connections[BDTEAMSERVER.BeyondHealthCharge].Properties[InitialCatalog]" ValueType="String">

<ConfiguredValue>BeyondHealthCharge</ConfiguredValue>

</Configuration>

<Configuration ConfiguredType="Property" Path="Package.Connections[BDTEAMSERVER.BeyondHealthCharge].Properties[Name]" ValueType="String">

<ConfiguredValue>BDTEAMSERVER.BeyondHealthCharge</ConfiguredValue>

</Configuration>

<Configuration ConfiguredType="Property" Path="Package.Connections[BDTEAMSERVER.BeyondHealthCharge].Properties[Password]" ValueType="String">

<ConfiguredValue></ConfiguredValue>

</Configuration>

<Configuration ConfiguredType="Property" Path="Package.Connections[BDTEAMSERVER.BeyondHealthCharge].Properties[ProtectionLevel]" ValueType="Int32">

<ConfiguredValue>1</ConfiguredValue>

</Configuration>

<Configuration ConfiguredType="Property" Path="Package.Connections[BDTEAMSERVER.BeyondHealthCharge].Properties[RetainSameConnection]" ValueType="Boolean">

<ConfiguredValue>0</ConfiguredValue>

</Configuration>

<Configuration ConfiguredType="Property" Path="Package.Connections[BDTEAMSERVER.BeyondHealthCharge].Properties[ServerName]" ValueType="String">

<ConfiguredValue>BDTEAMSERVER</ConfiguredValue>

</Configuration>

<Configuration ConfiguredType="Property" Path="Package.Connections[BDTEAMSERVER.BeyondHealthCharge].Properties[UserName]" ValueType="String">

<ConfiguredValue></ConfiguredValue>

</Configuration>

</DTSConfiguration>

Can somebody help me?

View 4 Replies View Related

Error When Save A Copy Of Pakage In SQL Server

Feb 15, 2007

Dear All,

I just created SSIS in my local computer. It is successfully run if trigger manually. I want the SSIS triggered by SQL_proxy_agent.

So, I try to save the copy of SSIS pakage in SQL Server but there is an error appear:

Error Code 0x80040E09: Execute Permission denied on Object ' sp_dts_getfolder', database 'mdsb', shema 'dbo'



Could anyone clear my doubt.



Thank you.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved