|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Invalid OLEVERB structure - CreateFile error Posted by MikeV06 at 4/14/2006 2:32:32 PM SQL Server 2000 on Win 2003 System
A Windows 2000 Workstation authenticates to the Win 2003 (domain
controller). The user starts Enterprise Manager with two registrations. One
to the local SQL Server 2000 Pro and the other to the Win 2003 SQL Server
2000 Standard. The Windows 2003 security gro...more >>
Find My InstanceName in DTS Activex Script Posted by Fergus at 4/14/2006 1:55:02 PM I have 2 sql server 2000 instances on the same server. One is servername
(local), and one is servername\test.
I have the same DTS Packag in both. When the package is running I want to
know which server instance I am on, so I can set up connections (put
instancename in DataSource Property) , e...more >>
how do you bulk copy into text file? Posted by br at 4/14/2006 11:10:02 AM I am looking through Books Online, and I cannot find a clear example on how
to Bulk Copy from SQL Server into a text file (for archiving old data).
The only line I could find states: "Bulk copying supports the following bulk
copy transfers: ...., From a SQL Server table or view into a data ...more >>
DTS--2000 vs. 2005 Posted by childothe1980s at 4/14/2006 9:13:01 AM Hello:
I don't understand why I could always use DTS without error in SQL 2000 but
get nothing but errors in SQL 2005.
All I am trying to do is to create a simple table, by DTS'ing a csv file
that was created from DTS'ing data from another table. Let me explain.
I have a database named...more >>
clone databases? Posted by MikeV06 at 4/13/2006 10:20:36 PM I am trying to find a method to clone a database within a server. I have
tried Backup/Recovery and detach/attach approaches. I can create the clone
with its own set of data/log files. However, the cloned database's property
data tab and log tab still lists the original file name even though
ever...more >>
Using Posted by Orlando at 4/13/2006 7:39:02 PM I'm using the function FINDSTRING in a derived column transformation in SSIS.
If I need to find the location of special characters like quotation marks,
how do I specify them to be searched within the string?
FINDSTRING([ColumnName], ???, 1)
Is there anything like a chr$() function I can use...more >>
Copying 69 million records using DTS package Posted by Rosie at 4/13/2006 5:52:02 PM Hi,
Can I copy a table with 69 million records from one database to another in
the same server using DTS package? Or I have to create a stored procedure to
read and insert, for example 50000 records each time (in this case we will
have a slow process)?
Does DTS use transaction log like ...more >>
Different Excel Macro Output when executed from DTS Package Posted by javathehutt at 4/13/2006 3:23:39 PM Hi Folks
Stumped here.....
I am able to call and execute an Excel Macro from a DTS ActiveX task
object. However, I get a different output on the Excel sheet when I do
it this way, compared to if I ran the macro directly in Excel. I can't
seem to find out why. I have attached the code snippe...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Threads Posted by Jim Heavey at 4/13/2006 2:07:02 PM I have on package which has run 3 sets of truncated all rows in the table and
then loads a new version of the table. The loading of the data into the
table run consecutively rather concurrently. I there a way that I can make
then run concurrently?
Likewise, if I have a package which execu...more >>
SSIS OLE DB Destination Posted by Ram at 4/13/2006 11:29:02 AM Is it possible to set the Connection manatger's Server Name dynamically. For
Example i am exporting data from a SQL server to a MS access File. I need to
change the name of the access file i am exporting data to , dynamically.
...more >>
Error when importing flat file in SSIS Posted by Sampa2870 at 4/13/2006 11:23:02 AM I'm trying to import a flat file using Integration Services. I'm getting a
weird error when creating a new connection using Connection Manager.
Error Message: "The field, Header rows to skip, does not contain a valid
numeric value"
My file does not have any header rows to skip, so I want t...more >>
SSIS Hanging Posted by working_developer at 4/13/2006 9:03:03 AM I am trying to run 30 SSIS packages that from an ETL process. Each package on
its own works and I am now calling the packages through a manager package.
After a few packages have run, SSIS just seems to freeze.
There are no blocking processes, no locks no errors anywhere. SSIS just
seems t...more >>
Flat File Source - Skipping Corrupted rows Posted by Eric at 4/13/2006 7:57:02 AM I do a nightly import from a comma delimited text file that is downloaded
nightly.
Quite often, the data will contain a corrupt, ususally in the form of an
incorrect delimiter. Well, this causes the whole package to fail. I have
tried redirecting rows, but no result. I was hoping there...more >>
Compare Data Posted by Terry at 4/13/2006 6:03:02 AM How can I compare data in tableA on ServerA against tableB on ServerB and
insert/update data to tableB on ServerB based on success/fail conditions?
What tasks should be used and how?
Thank you....more >>
DTS Package Fails With This Error: Line 1: Incorrect syntax near ' Posted by Warren at 4/13/2006 5:01:02 AM Hi,
Has anyone seen this error and know how to correct it?
Line 1: Incorrect syntax near '/'. [SQLSTATE 42000] (Error 170) The
identifier that starts with
'Z0xDACA57B0C1C78A9F5FAB370FD23FEFC72AF239EB4BCF820D2EE90034267F654F7980902B0FF2E492926AAAB562CD7FB0F9136409AF1EF80F28D2F75CCB063'
i...more >>
Connection string passwords Posted by JasonB at 4/13/2006 2:06:02 AM Hello all.
I have built a simple ETL package.
I have an OLE DB source, which then is multicasted. The first output is
pumped into a SQL Server DB and the second one goes into a script destination
which runs an UPDATE on the "Source" table setting a flag field to indicate
that the records ha...more >>
SQL 2005 SSIS issue with OLE DB Posted by Ram at 4/12/2006 5:39:02 PM I am exporting data from a SQL server to a Access DB with some custom Queries.
In the process I get a error between a Data conversion and OLE DB
Destination module
[OLE DB Destination [28]] Error: An OLE DB error has occurred. Error code:
0x80004005. An OLE DB record is available. Source...more >>
Grant exec DTS permission Posted by mecn at 4/12/2006 4:13:28 PM Hi,
I created a DTS job, I need win user group able to exec that DTS through
TDYrun untility.
How do I grant permssion to that group
Thanks
...more >>
Performing lookups with recordset variables Posted by Brandon Lilly at 4/12/2006 4:04:02 PM Is it possible in SSIS to perform a lookup with a recordset variable? I
looked at the lookup component, but it only wants a database table to perform
a lookup with and my data is in a flat file (that I don't want to have to
stick in a permanent table).
Can this only be done using a script ...more >>
source text file as input parameter from a stored procedure Posted by jgilmore NO[at]SPAM athensgroup.com at 4/12/2006 3:53:17 PM Here's my dilemma.
I am using an active X script (data pump) in combination with a global
variable to assign a variable text file name as input to a DTS data
transform task that loads data from a .txt file to a table. Also, I
have a stored procedure wrapper that calls the dts job with a param...more >>
DTS Data Driven Query - Update column only if source not NULL? Posted by ralekel NO[at]SPAM comcast.net at 4/12/2006 1:24:47 PM I'm trying to use a data driven query to update a destination table
with overrides imposed by another table. This override table contains
some records where only certain columns are overriden. Columns I do not
wish to override for a particular record are left NULL.
Is there a simple way I can us...more >>
SQL 2005 SSIS Issue Posted by Ram at 4/11/2006 4:26:01 PM I migrated a DTS package from SQL2000 to SQL 2005 , when i try to run it
using a stored procedure I get this error.
Description: Failed to decrypt protected XML node "DTS:Password" with error
0x8009000B "Key not valid for use in specified state.". You may not be
authorized to access this in...more >>
Failure constraint for execute SQL task Posted by Matt D at 4/11/2006 3:40:01 PM When executing a sql task, how do you get the failure constraint to be
tripped? I want an email to be sent when a sql script is not
successfully executed, but the package just seems to end and never
executes the send mail task. I've tried using RAISERROR() but that
doesn't seem to work either. W...more >>
SSIS FTP file Renaming on remote server. Posted by TK at 4/11/2006 9:54:02 AM How would you do this with SSIS ftp task.
How would you do this with wild cards, example:
File Name: test001.zzz
Rename to : test001.old
ftp>rename test*.zzz test*.old.
Any help thanks...more >>
SSIS - Conditional split Posted by scuba79 at 4/11/2006 7:45:02 AM I have a couple of tables that I'm importing from Oracle into SQL 2005 and
I'm importing them into one table. Unfortunately I'm finding out that the
tables have duplicate data. After importing the first table from oracle, is
there a way of check the "new" SQL table for existing records and i...more >>
DTS Package Fails when scheduled as a job. Posted by Warren at 4/11/2006 5:58:03 AM Hi,
Has anyone seen this error? I have created a DTS that executes a .bat file,
which looks at a .txt that has all the FTP parameters. The failure codes is
as follows:
Step 'DTSStep_DTSCreateProcessTask_1' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Packag...more >>
weird warning... Posted by Enric at 4/11/2006 12:25:01 AM morning/afternoon,
Any idea about this warning?Sql server is now focused doing reindexes and
I'm seeing this:
WARNING: EC 71f18098, 1 waited 900 sec. on latch 629a4770. Not a BUF latch.
Waiting for type 0x3, current count 0xa, current owning EC 0x7219C098.
...more >>
Send Mail Task Posted by exkievan at 4/10/2006 4:23:01 PM How to configure Send Mail Task if we are using Domino server with Lotus
notes as client?
--
Thanks,
ID...more >>
submit a report Posted by doug at 4/10/2006 1:31:03 PM Is is possible to schedule a crystal report to run with a dts job?...more >>
SQL 2005 SSIS vs DTS Posted by David D. Cruger at 4/10/2006 1:20:02 PM We are starting to migrate to SQL 2K5 and I'm already disappointed in the
SSIS service. What I use to be able to do with a nice simple DTS package in
1 min now takes me 1 hour. I have simple needs; I want to copy approx 100+
tables from one database to another drop/overwrite all data, includ...more >>
Creating a global variable at run-time Posted by Ric at 4/10/2006 12:59:02 PM Hello, I am loooking for code that will demonstrate how to create/remove a
global variable(s) at run time through an ActiveX script in my DTS package.
Thanks!
Ric...more >>
Loading a busy database Posted by Tom P. at 4/10/2006 11:03:02 AM Any comments on how to load a busy database? I have a table in a SQL Server
database that is read-only (SELECT only) to all applications. The only
application that has any more permissions is the loading application. This
is done via SQL Server stored procedure. When the job runs at night ...more >>
FTP fails inconsistently Posted by dfontanesi NO[at]SPAM gmail.com at 4/10/2006 9:10:05 AM I have a simple FTP task in my DTS package. It downloads about a dozen
files from a remote server. But it never downloads all the files. I'm
always missing one or two, usually from the beginning of the
alphabetical order for some reason.
And when I keep an eye on the directory as the files ...more >>
Not enough storage space to process this command Posted by DeniseMe at 4/10/2006 7:00:02 AM Hello All,
I have a process which loads and executes a lot of DTS packages thru a
stored procedure using OLE Automation. This process had been running fine,
all the way thru. Now at different pkgs (different spots in the process), I
receive the following error when calling the load (SP_OAM...more >>
is the execute process task the way to go here? Posted by SQLCat at 4/10/2006 6:13:02 AM I have an execute process task that performs the following:
cmd.exe /c wzunzip \\servername\share\companyname.20060410.zip c:\dir\ -o
Rather than hard code the date, is there a way I can automate this task to
pick off the latest zip file?...more >>
search DTS for stored proc name Posted by Vikram at 4/10/2006 12:00:00 AM I want to search all DTS in my server for a specific sp name. Is there any
query or searching way by which i can do this without opening each and every
DTS
...more >>
DTS from sql express 2005 to 2000 Posted by Liming at 4/9/2006 11:30:41 PM Hi,
I tried to use sql express 2005 DTS converstion wizard from within the
Managment Studio and gerenate sql scripts to recreate the database into sql
2000.
So far, the scripts can't be excuted in sql 2000. What am I doing wrong?
In Sql express 2005, I did
1. right click on the datab...more >>
DTS adding new destination columns Posted by paulhux174 NO[at]SPAM hotmail.com at 4/9/2006 11:08:08 PM DTS
Adding new destination columns.
Can you using the DTS designer add new columns to the Destination?
I want to combine fields from the Source into some new Destination
columns.
Thanks
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |