| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | I would like to accomplish the following:
1. Send Mail to an email address and individual's name retrieved from a list
retrieved by a select...
VSLA
|
Yesterday 04:49 PM
VSLA | 0 | 3 |
|  | I am converting a simple (at least in the SQL Server 2000 DTS days) to this
new SSIS. I have a data source (which is Oracle 8 using .Net ODBC...
cindy
|
03-12-2010 08:23 AM
Raga | 10 | 201 |
|  | Can someone tell me if the "Microsoft Connectors for Oracle and Teradata by
Attunity" works on SQL Server 2008 Standard? The following link states...
greenmtnsun
|
03-11-2010 06:09 PM
greenmtnsun | 3 | 47 |
|  | If I have an "Execute SQL Task" with sql that looks like this:
SELECT FLAG FROM "MyDB"."RUNorHOLD"
WHERE FY = '2010' AND PER = '4'
How can I turn...
robboll
|
03-11-2010 08:38 AM
ROBBOLL | 2 | 33 |
|  | I have an execute sql task with the following query against adventureworks2008
SELECT description, modifieddate
FROM ...
Mark
|
03-11-2010 07:59 AM
Todd C | 1 | 14 |
|  | hi,
i would like to know how i can create a dts package which contains 3
queries, each creating a separate csv file. can someone list the steps...
geebee
|
03-08-2010 09:29 PM
geebee | 0 | 12 |
|  | We are new to SQL Server 2005. When we import SSIS Package, there are 2
options - File System or MSDB file.
Which one should we choose ?
Thanks
Patrick
|
02-23-2010 02:46 PM
Patrick | 2 | 57 |
|  | Hi,
During a project I gained a lot of knowledge of using the Theobald Xtract IS
DeltaQ component, which I like to share with you all.
I have...
Johan Machielse
|
02-22-2010 08:35 PM
Todd C | 1 | 44 |
|  | We have written a simple app that executes a simple DTS package constantly to
monitor memory. We were expecting to see memory usage maintained at the...
Webmonkey26
|
02-12-2010 03:17 AM
Webmonkey26 | 4 | 75 |
|  | I am using SQL Server 2005 and trying to import a CSV file on the web. I am
not a programmer so I was just trying to use the import and export...
RedGlow06 via SQLMonster.com
|
02-11-2010 03:25 PM
RedGlow06 via SQLMonster.com | 0 | 33 |
|  | 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 12:20 PM
Todd C | 1 | 28 |
|  | 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 03:26 AM
MR:K | 3 | 80 |
|  | 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 07:56 AM
Todd C | 3 | 66 |
|  | 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 05:00 PM
antivirus gratis | 0 | 33 |
|  | 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 09:13 AM
Todd C | 1 | 29 |
|  | 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 05:22 AM
Miguel Canas | 0 | 28 |
|  | 許多性能問題和安全性您的計算機*成惡意病毒,最好的辦法對付,這是得到承認和防病毒在計算機上安裝更新
...
antivirus gratis
|
02-02-2010 06:20 PM
antivirus gratis | 0 | 50 |
|  | 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 09:06 AM
robboll | 0 | 38 |
|  | 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 08:30 AM
Gerald Aichholzer | 2 | 42 |
|  | 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 07:38 AM
Todd C | 1 | 33 |
|  | 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 02:42 PM
imani_technology_spam@yahoo.com | 4 | 65 |
|  | 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 12:27 PM
MSExpert | 2 | 107 |
|  | 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 10:26 AM
teg | 2 | 48 |
|  | 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 07:39 AM
antivirus gratis | 0 | 32 |
|  | 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 03:27 AM
Alastair Williamson | 0 | 33 |
|  | 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 02:22 AM
thierry | 0 | 42 |
|  | 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 04:40 PM
Ked | 0 | 37 |
|  | 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 01:25 PM
Ked | 0 | 36 |
|  | 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 10:18 AM
Hotwheels | 0 | 35 |
|  | Best approach to import tables.
I have the following databases
1. Current (only hold current month)
2. Archive
Fsb
|
01-22-2010 07:59 AM
Todd C | 1 | 47 |
|  | 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 11:38 AM
jWhytis | 5 | 78 |
|  | 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 03:04 PM
doug | 0 | 46 |
|  | 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 12:03 PM
SQL Programmer | 1 | 37 |
|  | 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 05:48 PM
antivirus gratis | 0 | 48 |
|  | 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 06:12 PM
imani_technology_spam@yahoo.com | 0 | 44 |
|  | 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 02:35 PM
imani_technology_spam@yahoo.com | 0 | 41 |
|  | 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 07:47 AM
Todd C | 1 | 66 |
|  | 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 04:01 PM
brath | 0 | 46 |
|  | 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 07:49 AM
Todd C | 2 | 54 |
|  | 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 02:12 PM
. | 0 | 47 |
|  | 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 08:00 AM
Todd C | 3 | 70 |
|  | 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 11:43 AM
tbradshaw via SQLMonster.com | 4 | 55 |
|  | 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 06:42 PM
Adrian | 2 | 325 |
|  | 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 03:24 PM
Todd C | 1 | 64 |
|  | 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 04:00 AM
Ian Beckett | 1 | 136 |
|  | 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 10:40 AM
Joachim Hofmann | 2 | 108 |
|  | 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 01:01 PM
Pinky9595 | 0 | 78 |
|  | 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 11:53 AM
Todd C | 1 | 54 |
|  | 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 07:49 AM
Todd C | 2 | 78 |
|  | 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 12:39 PM
Todd C | 1 | 61 |