| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I have a simple table with five columns. One of the column is a
date.
When I import the data into a datetime field I get the error: An OLE
DB...
robboll
|
07-06-2010 05:52 AM
Gorm Braarvig  | 2 | 153 |
 | | I'd like update a parameter with the SQL Query Property (or the select
statement of the source table) in an SSIS Task. Does anyone have any...
jm27102
|
07-01-2010 09:19 AM
jm27102 | 0 | 42 |
| | | Hi!
I have a table with 3M records on an ORACLE DB. A record can fit about 300K
Bytes. Don't ask me why, this was not my design.
I am trying to...
Jose
|
06-29-2010 11:49 PM
Geniusinuse | 1 | 60 |
| | | Predictive Analytics World Conference – October 19-20, 2010 -
Washington, DC
Dates: October 19-20, 2010
Location: Washington,...
EliseJ
|
06-28-2010 01:34 PM
EliseJ | 0 | 38 |
| | | Hi!
I have a table with 3M records on an ORACLE DB. A record can fit about 300K
Bytes. Don't ask me why, this was not my design.
I am trying to...
Jose
|
06-21-2010 08:21 PM
Jose | 0 | 33 |
| | | Hello,
i want to backup my mssql server 2005. is there any way to backup sql
database to txt, doc, xls etc.. format? not .bak file format.
thanks
gulerayh
|
06-18-2010 06:12 AM
Paul Shapiro | 1 | 57 |
| | | Hi all,
i hope this is an easy question...
i have an SSIS package that tries to do step A. if that fails, we have it
set to on-failure do step...
Joe Sampino
|
06-17-2010 11:32 AM
Joe Sampino | 0 | 41 |
| | | I am trying to use "OLE DB Source" for SQL Server and "DataReader
Destination" for AS400.
If I do other way, from AS400 to SQL Server, I was able to...
Justin D.
|
06-15-2010 05:24 PM
Justin D. | 0 | 40 |
| | | Hello SSIS Gurus! I am putting together an SSIS job that dumps and
repopulates a delimited record source nightly, but there is nothing in
the data...
robboll
|
06-15-2010 05:06 PM
robboll | 0 | 35 |
| | | We have SaveCheckpoints set to True. In a script block we are converting the
Recordset to a DataSet using the following sample code. If we...
bsk_WF
|
06-15-2010 04:41 PM
bsk_WF | 1 | 33 |
| | | I have a DTS package with Transformations that look like this:
Function Main()
DTSDestination("PART_PAY_PAYMENT") =...
robboll
|
06-14-2010 04:20 PM
robboll | 0 | 40 |
| | | Hi,
I am trying to run an SSIS package from SQL server agent.
The package has one script task that uses an ADO connection.
When running the package...
shnel
|
06-11-2010 07:45 AM
Bernardo Romero | 5 | 194 |
| | | Hi,
trying to run an SSIS package (SQL 2008) using the 32bit DTEXEC (due to
32bit Oracle client) on Windows 2008 64bit with 64GB of RAM. The...
Landry
|
06-10-2010 09:10 PM
Landry | 0 | 33 |
| | | Am running in BIDS using the SQL 2005 SSIS sharepoint list source and
destination source to identify the doc lib. Have a test doc lib setup with...
HaroldH
|
06-10-2010 09:26 AM
HaroldH | 0 | 40 |
| | | Is it possible to use variables that are specific to a sequence container
only ?
Variables are available in the Control Flow and Data Flow Task areas...
jm27102
|
06-08-2010 11:14 AM
jm27102 | 0 | 45 |
| | | Hi,
I am having a strange issue while setting up package configurations. First,
I have set up an environment variable with the below value:
Data...
Neeraj
|
06-07-2010 04:18 PM
Neeraj | 0 | 32 |
| | | I'm a newbie to SQL Server 2008 Integration Services (I have done some
DTS packages in SS 2000) and I
was wondering why the Fuzzy Lookup component...
Crazy Cat
|
06-07-2010 10:31 AM
Crazy Cat | 0 | 35 |
| | | Hi there,
I'm using SQL Server 2008
And I have a table called myProgress with column name summary data type xml
looks like that
<?xml...
odeddror
|
06-05-2010 02:58 PM
odeddror | 0 | 45 |
| | | Our nightly datawarehouse update processing is periodically failling on an
irregular basis. No useful errors in Windows logs, SQL logs, or SQL...
dworxClint
|
05-28-2010 10:31 AM
Carla Sabotta | 1 | 137 |
| | | Any idea how to diagnose a timing out error?
Sometimes it happens when the package just starts running, other times after
it has processed thousands...
Dorian
|
05-27-2010 04:44 PM
Dorian | 0 | 55 |
| | | What is Happening?
This message is to inform you that Microsoft will soon begin discontinuing
newsgroups and transitioning users to Microsoft...
nntp@microsoft.com
|
05-21-2010 04:54 AM
nntp@microsoft.com | 0 | 69 |
| | | We are having a strange problem with a DTS package running on SQL 2005 after
our upgrade from SQL 2000 this week. The first step of the package just...
Jason Fisher
|
05-20-2010 10:55 AM
Jason Fisher | 0 | 73 |
| | | I am very new to SSIS 2005
I have a sql command Select count(*) from table_a. The result is stored in
a global variable. In a script task, if the...
The Other Mike
|
05-18-2010 07:45 AM
Todd C | 1 | 109 |
| | | I am using SSIS 2005 to import a text file, do some lookups and then
send the output to subfolders on the destination hard drive based on
certain...
imani_technology_spam@yahoo.com
|
05-13-2010 10:46 AM
Todd C | 1 | 99 |
| | | Hi all, been working on this problem for a while now but having little
success finding a satisfactory solution.
I have a DTS package which contains...
VegaLA
|
05-10-2010 04:41 PM
VegaLA | 0 | 77 |
| | | Ok Gurus,
Here is an interesting situation, I have a coworker that has a flat file
with no column headers that needs to be imported or appended into...
Bill Orova
|
05-05-2010 03:49 PM
Todd C | 1 | 153 |
| | | What could go wrong here?
I created a simple DTS Package to copy one DB from server A to server B
using the Copy Database Wizard. The Package is...
David
|
05-03-2010 03:56 AM
David | 0 | 71 |
| | | I have some scheduled dts packages. They error out with this message every
time. I can run the package manually with no problem.
Step 'Copy Data...
Leslie
|
04-29-2010 09:51 AM
Gaurav | 4 | 290 |
| | | Hi --
MS SQL2008. I want to export a table1 to MS Access so I using Export data.
While it is exporting to the last step I got an error " OLE DB Size...
MN
|
04-29-2010 07:50 AM
Todd C | 1 | 77 |
| | | I'm getting "The Data Pump Task requires Transformations to be specified"
error.
The package has everything specified correctly. The package was...
Dorian
|
04-26-2010 05:48 PM
Dorian | 0 | 88 |
| | | Hi
I have a really simple DTS package that loads a .csv into a table using a
Transform Data Task.
Very occasionally, I get a primary key violation...
NH
|
04-23-2010 07:28 AM
Paul Shapiro | 1 | 145 |
| | | I’m having difficulty figuring out why the sample HelloWorld custom
task is not showing up inside of BIDS (SSIS Data Flow Items tab).
I’ll be...
Dave
|
04-16-2010 06:24 PM
Dave | 0 | 88 |
| | | We have DTS package with isolation level of 'read commited'.
In this is a vbscript task that opens a recordset and loops through it.
Question: is it...
Dorian
|
04-15-2010 04:12 PM
Dorian | 0 | 89 |
| | | Hello all,
I have a execute sql task in a container with other tasks. This is all the task has in it DECLARE @RC int
EXECUTE @RC = ...
William E. Booth
|
04-09-2010 05:06 PM
William E. Booth | 3 | 167 |
| | | I am executing a sql file through dts. Is is possible to get complete
sql execution log (i.e. so many rows updated etc.) and not just step
failure...
pradeep
|
04-08-2010 10:05 AM
Zodiac | 7 | 199 |
| | | SSIS Community:
I have some .txt files I need to work with in SSIS. When I create a Flat
File connection, the connection manager does not seem to...
JJ of Eugene OR
|
04-05-2010 11:13 PM
SQL Lion | 12 | 509 |
| | | 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
|
04-01-2010 03:41 PM
Doug Ivison | 11 | 470 |
| | | Hi
I want to edit a query that I pasted into the DTS package when running the
import wizard. Is there a way to do this without having to rerun the...
Mitchell_Collen via SQLMonster.com
|
03-31-2010 01:12 PM
Mitchell_Collen via SQLMonster.com | 0 | 89 |
| | | In order to copy all files in certain folder to another folder (with the same
file name) I have placed a File System Task inside the foreeach...
rkbnair
|
03-30-2010 02:15 PM
Joshi | 81 | 408 |
| | | Hi Guys,
I'm currently using SSIS to copy data from a source table, change some
of the datatypes and pump it into a destination table.
The problem...
lloyddsilva@gmail.com
|
03-30-2010 08:04 AM
sneha | 3 | 132 |
| | | Hi -
I'm not familar with DTS deatils. I was wondering if Microsoft has a tool in
either SQL 2k5 or SQL 2k5 SSIS which "converts" SQL 2k DTS...
Steve M
|
03-30-2010 07:36 AM
Todd C | 1 | 89 |
| | | Hopefully someone can help me with this. I have an SSIS package that
runs great in all my environments. However, this package recently
stopped...
Chris
|
03-29-2010 04:05 PM
Ricky Hall | 10 | 478 |
| | | I'm (attempting to) converting a legacy Perl program to SSIS. The apps
purpose is to sign in to a web service, submit a request and receive an...
Peter
|
03-29-2010 11:29 AM
Peter | 0 | 82 |
| | | Is there a way for a DTS script (vbscript) to tell which server it is running
on?
Is there any reason I cannot set a variable using this technique...
Dorian
|
03-24-2010 11:09 AM
Dorian | 0 | 131 |
| | | How are DTS packages normally promoted from development to test and test to
production?
I need to update a DTS package, both the number of steps in...
Dorian
|
03-24-2010 09:23 AM
Dorian | 2 | 99 |
| | | Hi,
I have a problem which is causing us grief and we don't know where to look
next.
We have an SSIS package. The said package runs at an acceptable...
Kevin
|
03-23-2010 06:44 AM
Todd C | 1 | 101 |
| | | Hi,
I am having a problem doing a quick and dirty export from a table to a csv
file. It is not a job just a quick run, never experienced this...
Brian
|
03-23-2010 06:40 AM
Todd C | 1 | 98 |
| | | 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
|
03-19-2010 04:05 PM
greenmtnsun | 1 | 179 |
| | | So if we created a an OLE DB Source with this SQL
select field_1, field_2, field_3
from table_1 For XML AUTO
It would create xml results from the...
Hotwheels
|
03-18-2010 11:31 AM
Hotwheels | 0 | 83 |
| | | Please advice on How to Execute a DTSX package from VB.Net 2003.
chiks81
|
03-18-2010 05:45 AM
Todd C | 1 | 90 |
