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
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
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
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