I'm trying to make a DTS package to update a field in SQL. This package would run once per week or when a user forces it to run using a batch file...

dorkygrin

02-11-2010 01:20 PM
Todd C

You can redistribute the dlls using this Redistributing DTS with your program (http://www.sqldts.com/default.aspx?225) Executng a package in Excel...

Sib

02-11-2010 04:26 AM
MR:K

Whenever I paste in some Vba code from an ms access module it errors on parts of the code that I have no problems with in Access. I couldn't find a...

robboll

02-08-2010 08:56 AM
Todd C

Many problems with performance and safety of your computer can be solved easily with an updated antivirus and recognized. Antivirus Free...

antivirus gratis

02-07-2010 06:00 PM
antivirus gratis

Hello, I'm a newbie in DTS's and Integration Services, but I need to migrate a DTS to Integration Service but it's failing when i'm migrating the...

Miguel Canas

02-05-2010 10:13 AM
Todd C

Hello, I'm a newbie in DTS's and Integration Services, but I need to migrate a DTS to Integration Service but it's failing when i'm migrating the...

Miguel Canas

02-05-2010 06:22 AM
Miguel Canas

許多性能å•�題和安全性您的計算機é€*æˆ�惡æ„�病毒，最好的辦法å°�付，這是得到承èª�和防病毒在計算機上安è£�æ›´æ–° æ...

antivirus gratis

02-02-2010 07:20 PM
antivirus gratis

I have an "Execute SQL Task" that has hard coded values like: SELECT CLSD_FL FROM "AMS_FINUSER"."R_APD" WHERE FY = '2010' AND PER = '4' FY = Fiscal...

robboll

02-02-2010 10:06 AM
robboll

We have an Oracle database linked into a SQL Server. Is it possible to use SSIS to import a text file into a linked server? Why don't we just...

imani_technology_spam@yahoo.com

02-02-2010 09:30 AM
Gerald Aichholzer

I am running into an issue that no matter how I format the Prepare SQL task, it puts a "_" in the tab name. CREATE TABLE `Data Format` Show up as...

DomitianX

02-02-2010 08:38 AM
Todd C

I am trying to use SSIS to import a text file into an Oracle database. However, I get the following error: "Test connection failed because of an...

imani_technology_spam@yahoo.com

02-01-2010 03:42 PM
imani_technology_spam@yahoo.com

And what is the query. I have seen this error mentioned when there is a USE statement as the first part of the query. What about reregistering...

Allan Mitchell

01-29-2010 01:27 PM
MSExpert

Hi, Im trying to upgrade an old DTS package that uses the date programitically to load a table from an AS400 database. Even though the table name...

teg

01-29-2010 11:26 AM
teg

Muchos problemas de rendimiento y seguridad de tu computador son causados por virus maliciosos, la mejor forma de combatir esto es tener instalado...

antivirus gratis

01-29-2010 08:39 AM
antivirus gratis

Hello, Can anyone tell me if there are any security concerns when using an SSIS package to push data from our SQL 2005 server (in our corporate...

Alastair Williamson

01-29-2010 04:27 AM
Alastair Williamson

Hi everybody, Is there a way to edit/modify DTS on SQLServer 2000 without the DTS Designer, in order to apply upgrades to all the table of a...

thierry

01-27-2010 03:22 AM
thierry

Hi All, I am using SQL Server 2000 - DTS. I have multiple database connection & datapumps - running in parrallel. All uses same Global variable,...

Ked

01-25-2010 05:40 PM
Ked

Scenario : I have two SQL servers (both PROD), located in same city but hosted on different machines. I need to transfer data from one...

Ked

01-25-2010 02:25 PM
Ked

I have two Input Columns AddmissionDateStart and AddmissionDateEnd and I am not able to access the value inside the variables in the script? The...

Hotwheels

01-25-2010 11:18 AM
Hotwheels

Best approach to import tables. I have the following databases 1. Current (only hold current month) 2. Archive

Fsb

01-22-2010 08:59 AM
Todd C

Hello All, I was wondering it it is possible to ftp the results of a SQL Query without first saving those results to a file. Thanks

jWhytis

01-21-2010 12:38 PM
jWhytis

I am using SQL 2005 SSIS. I have created a package that imports and exports data and have captured an error log for any bad import records. What i...

doug

01-18-2010 04:04 PM
doug

Hello: I have created a SQL 2005 SSIS job. It will not run. When I check the history, it says "Login failed for user 'sa'" and "Connection may not...

SQL Programmer

01-18-2010 01:03 PM
SQL Programmer

Many computer problems are caused by viruses and malware on your computer. The best and easiest way to correct this is to use a recognized antivirus...

antivirus gratis

01-15-2010 06:48 PM
antivirus gratis

I am trying to import data into a Vertica database using SSIS. Vertica says I can use an OLE DB provider for ODBC. Is there an SSIS 2005 Connection...

imani_technology_spam@yahoo.com

01-14-2010 07:12 PM
imani_technology_spam@yahoo.com

Does anyone out there have any experience with using SSIS to import data into Vertica? If so, what were the challenges?

imani_technology_spam@yahoo.com

01-14-2010 03:35 PM
imani_technology_spam@yahoo.com

my package is to refresh dimension tables when i excute it directly from the designer it execute correctly even i execute it from Execute package...

mohamed maoodah

01-13-2010 08:47 AM
Todd C

Hello, I have created a package that loops through multiple folders and inserts (the file path and name) of any new files within these folders into...

brath

01-11-2010 05:01 PM
brath

Is there a way, in SSIS 2005, to have one data conversion transformation connect to multiple SQL Server destination objects? It isn't working for me.

imani_technology_spam@yahoo.com

01-11-2010 08:49 AM
Todd C

Driving and Car Maintenance: Transportation accounts for 66% of U.S. oil use -mainly in the form of gasoline. Luckily, there are plenty of ways to...

.

01-10-2010 03:12 PM
.

Here are the details: - Source is a 5 GB text file. It is in a "ragged right" format with NO character delimiters. - Destination is 20...

imani_technology_spam@yahoo.com

01-08-2010 09:00 AM
Todd C

Hi, Just wanted to know how we can convert MS SQL 2000 DTS packages to MS SQL 2005 Please send step by step instructions

Rena

01-07-2010 12:43 PM
tbradshaw via SQLMonster.com

I have a need to pass an argument to an executable in an SSIS package. The value of the argument is not static, it will vary at execution time, so...

js

01-06-2010 07:42 PM
Adrian

WIndows SQL2008 & Windows 2008R2 I opened a 2005 dtsx in BIDS ( 2008 ) and after a few sdjustments it runs fine. The dtsx imports data from a flat...

Peter Newman

01-06-2010 04:24 PM
Todd C

The code below works perfectly when I run the webservice in debug mode. I can invoke any of the webmethods including the one below. This...

Whiskey Romeo Lima

01-01-2010 05:00 AM
Ian Beckett

Hello, I migrated a DTS-Package to SSIS. There is an ActiveX-Task in vbscript I d like to rewrite in a new VB.Net Scripttask. The task sets the...

Joachim Hofmann

12-30-2009 11:40 AM
Joachim Hofmann

Question: The WMI return value only returns if the command line is submitted. How can you tell if it finished and what value was returned? This is...

Pinky9595

12-22-2009 02:01 PM
Pinky9595

I am trying to run a sql statement as part of a DTS package. I've tried variations of the following: Update tblPlayers Set tblPlayers.IsNoMail...

Watson78

12-22-2009 12:53 PM
Todd C

I have sql server 2000 installed om windows 2000 server. All service-packs are installed. I have many DTS-jobs running, and they have been running...

Tore

12-22-2009 08:49 AM
Todd C

Has anyone ever used Examdiff to examine changes in SSIS packages? Also, does anyone have any opinions of Apex SQL SSIS Compare?

imani_technology_spam@yahoo.com

12-21-2009 01:39 PM
Todd C

Hi Everyone, Just a reminder to save the date: Predictive Analytics World conference, Feb. 16-17, 2010, San Francisco. Includes keynote speakers...

EliseJ

12-21-2009 01:27 AM
EliseJ

I am reposting this problem because I originally posted with the incorrect problem. I have a simple SSIS package executing perfectly in the BID...

Whiskey Romeo Lima

12-18-2009 03:53 PM
Whiskey Romeo Lima

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the...

Mia

12-17-2009 10:31 AM
Mia

In SQL2000 I can execute a DTS package with this code just fine DTS.Package2Class test = new DTS.Package2Class(); object pVarPersistStgOfHost =...

jimd

12-16-2009 05:46 PM
Hui

I have a table that contains the following columns: date_column start_time end_time and would like the dts job to look up the above table and run it...

12-11-2009 09:14 AM
Todd C

I have an instanace of SQL 2005 and 2008 residing on the same box. Most of our data resides on SQL 2005. I am using VS 2008 to maintain and develop...

Tagwim

12-11-2009 08:59 AM
Todd C

I have a requirement to import data from one SQL Server (2005) database, to another, transforming the data on the way through. So, DTS seems to fit...

Craig Lister

12-11-2009 08:50 AM
Russell Fields

I have SQL 2005 and 2008 on the same box. Can I install 2005 and 2008 Integration Services on the same box also? I currently have 2008...

Tagwim

12-10-2009 09:25 AM
Tagwim

Hi, in my stored procedure, that start the execution of a SSIS package with dtexec command, I receive this error: The EXECUTE permission was denied...

Luigi

12-10-2009 08:59 AM
Todd C

Windows 2003 (Standard x64) SP2 named "W2003XXX". SSIS Server is therefore named "W2003XXX". SQL Server 2005 (Standard x64) Build 9.00.1399.06 named...

Van T. Dinh

12-09-2009 11:44 PM
Van T. Dinh