|
|
|
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 OLE DB error / DBNETLIB ConnectionRead Posted by James Wuerflein at 9/28/2006 2:02:52 PM We have been getting a strange error with this particuar package that =
we've been running a scheduled job, from Integration Services and havn't =
been able to figure it out. It works fine when running from Visual Studio =
but not so much when we are scheduling it. Below is all of the OnErrors ...more >>
Import CSV file but ignore first 10 rows Posted by PizzaGood at 9/28/2006 12:29:36 PM Hi,
I am trying to build an automated process that would allow someone to upload
a CSV file via FTP to a specific folder and then the DTS package would do
it's thing every hour and import the information then delete the CSV file.
All of this is not a problem except that the first 9 rows co...more >>
DTSRUN option accept UNC path? Posted by Rick Charnes at 9/28/2006 12:12:10 PM I don't have accesss to DTSRUN. Can someone tell me if its /L
(log_file_name) argument will accept a UNC path? Thanks....more >>
SSIS SQL Task Dynamic File Source Posted by Marty at 9/28/2006 12:05:52 PM Greetings.
I have a folder containing a number of .sql files that I would like to
execute using Exec SQL task I'm looking for a way to dynamically set
the Exec SQL Task's FileConnection property using a ForEachLoop
container for the folder. Probably going to bring the path to the
folder ...more >>
DTS Compatibility between Service Packs Posted by HudsonHawk at 9/28/2006 12:01:01 PM I have a workstation with SQL Server SP4, and a server with SQL Server SP3a.
I use Enterprise Manager on the workstation (SP4) to remotely connect to the
server (SP3a) and create/modify DTS Packages. If I create/modify a DTS
Package that contains a FTP Task from the workstation (SP4), and then...more >>
Need Help - How would I accomplish this? Posted by Rick Bond at 9/28/2006 11:26:34 AM Hi, I need help accomplishing a task and I'm not sure how to go about it
but I do know that I want to do it using DTS.
I have a text file, A, with a list of id's and I'm supposed to execute a
SELECT query on each id and send the data to another text file, B. I'm
not even sure where to start.
...more >>
sample good tutorial on SSIS Posted by SQLKen at 9/27/2006 3:20:42 PM I am looking for some tutorial on SSIS, beside the one from MS online
tutorial.
Can you help?
thanks
ken
...more >>
Event Debugging Posted by Brian Bagley at 9/27/2006 10:32:01 AM I am trying to debug a script task in an event, is this possible? I get a
window that opens and contains the script task from the control flow but that
is all I ever see. Any help would be appreciated. I am not sure what
additional info is needed to help diagnose this, but I will provide wh...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
openrowset to dbase files, specifically what drivers Posted by Steve Mull at 9/27/2006 8:55:30 AM Hi -
I have a 32 bit SQL Server 2000 installation that is current on service
packs that is installed on a 64 bit version of Windows 2003 (this actually
works ok). It's not mine, but I have to deal with it.
There are a few DTS packages I need to transpose into T-SQL that read from
dbase f...more >>
SSIS Package Errors Posted by bigbrorpi NO[at]SPAM gmail.com at 9/27/2006 8:42:09 AM Hi -
I've been having a problem with all of the packages I create. I create
them in BIDS on my local machine (which is running SSIS, as I
discovered that was needed for the packages to run properly on the
server). I then create an XML config file and deploy them to the file
system on the serv...more >>
System.IO.FileLoadException error on client pc Posted by Langston at 9/27/2006 7:01:02 AM Hi all,
How can I have my c# program execute a DTS package on a client PC that
doesn’t have SQL client tools installed?
I have a c# program that executes a DTS package on a SQL 2000 server. The
program works as expected when run on the development PC. When I install the
program on a cl...more >>
Connection to Oracle Posted by mcauliffe at 9/27/2006 4:56:01 AM This is a newbie question.
I'm starting a new DTS package. I click and drag the Microsoft ODBC drive
for Oracle to the IDE. I enter the inforamtion and click okay.
I received this error dialog box:
Title = Package Error
Text area
Error Source: Microsoft OLE DB Provider for ODBC Dri...more >>
Migrating DTS Packages on SQL 2000 to SSIS on 2005 Posted by KarenM at 9/27/2006 3:57:45 AM I have some DTS packages that load a flat file to the SQL 2000 database
and then to a AS 2000 cube. I want to migrate this to SSIS on SQL 2005
and AS 2005 kindly explain the procedure for the migration.
Thanks
Karen
...more >>
DTS Problem General Network error Posted by gollo007 at 9/27/2006 3:48:41 AM Hi Everybody,
I am having problems in DTS packages that runs nightly. It is
always the same Error at the same 'Execute SQL Task'. The ohter Tasks
in
the same DTS packages works fine with the same OLE connection.
"[DBNETLIB][ConnectionRead (recv()).]General network error.
Check your network...more >>
Error handling in ActiveX script task Posted by Gaye Turnbull at 9/27/2006 2:52:46 AM I am running several ActiveX script tasks that are basically inserting legacy data into the new DB structure. Using stored procedures with cursors has taken far too long so i wrote some relatively simple scripts that handle the job very well and very fast. However, I want to be able to write any e...more >>
DTSrun gives Package does not exist error Posted by artzoop NO[at]SPAM hotmail.com at 9/26/2006 2:29:33 PM Hi,
I am trying to run a DTS package from my SQL server command line using
DTSrun.exe. I cannot get the syntax right to find the package, for I
keep getting "The specified DTS package ... does not exist".
Here is the command I'm using:
C:\Program Files\Microsoft SQL Server\80\Tools\binn>Dt...more >>
Capture aggregate on Excel Source and verify it in SQL destination Posted by Lawrence Lau at 9/26/2006 1:16:03 PM I am import Excel files into SQL 2005. I need to capture the total from Excel
and compare the total in SQL destination table. If they are not equal, then
there is an error.
Did anyone know how to do it in SSIS?
Thanks....more >>
SSIS Repost - Can't see packages stored on server in BIDS Posted by sqlboy2000 at 9/26/2006 12:10:02 PM Can somebody from the MS team help me with this? I never got an answer.
I'm a sys admin on the SQL Server and working locally. I go into bids and
try to save a copy of a dtsx file to the server (SQL Server).
I can see the folders I've defined in integration services fine, but when I
expand the...more >>
inserting multiple rows Posted by Tony at 9/26/2006 10:42:49 AM We have an interesting scenario here at work which to be honest doesnt =
seem very difficult but we have never had the opportunity to try this =
out.
One of my co-workers has written a dts package containing one simple =
transformation. This dts package simply reads from a file and puts it =
in...more >>
SSIS DTS Template? Posted by BrianG at 9/26/2006 9:21:03 AM Converting mind and server to SQLServer 2005. Bought a book to help in the
transition. I need a new DTS project. I open SS Business Inteliigence Dev,
File, New Project, Intergration Services Project. My book example shows a
Data Transformation template. In real life, my server shows no tem...more >>
Foreach File enumerator missing in Foeach Loop containger after applying SP1 Posted by Lorents Nord-Varhaug at 9/26/2006 12:00:00 AM Hi.
After applying SP1 on my SQL Server 2005 developer edition on my laptop,
there is no longer a File enumeratorin the Foreach Loop container.
I have found this problem described earlier, but not yet found any solution
for this problem:
http://groups.google.dk/group/microsoft.public.sqls...more >>
cannot run a SSIS package via SQL Server Agent Job Posted by martino at 9/25/2006 6:16:01 PM Hello There,
I have a very simple SSIS package that I want to schedule to run via SQL
Server Agent Job, but so far I was not able to make to run.
The SSIS package runs fine within SS Management Studio and Business
Intelligence Development Studio (BIDS), but when I tried to run it in a
s...more >>
Activex in DTS Posted by rmcompute at 9/25/2006 3:23:02 PM Can anyone recommend a good book which deals strictly with using Activex in
DTS ? Is there an DTS Object Module similar to the Access Object Module and
a way to view it ? Are there methods and properties as in Microsoft Access
and a way to view them ?...more >>
calling dtexec from clr Posted by t2581 NO[at]SPAM hotmail.com at 9/25/2006 7:16:08 AM Hi,
we use xp_cmshell inside custom procedure to execute DTS and dtexec
is any way to create clr procedure that will call dtexec ?
could not find any examples exept
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=407609&SiteID=1
thanks
Alex
...more >>
Check for Existing Records in an Table in SSIS Posted by Sudhakara.T.P. at 9/25/2006 7:09:02 AM Hi,
I have an requirement wherein I get the data in the form of an txt file and
I need to push this data onto different tables based on an column. And while
pushing these data onto different tables, I need to check whether the data
already exists in the table based on an unique column. If it ...more >>
SSIS null password given when executing package Posted by mystical potato at 9/25/2006 5:14:01 AM I created a package configuration and used the package installation wizard to
deploy a package to my dev server.
The package pulls data from Oracles servers (9.2 Oracle client and
ADO.NET:System.Data.OracleClient.OracleConnection objects to connect to the
servers. In the package configurat...more >>
Copy DTS to new server - problem Posted by Bob at 9/25/2006 4:39:01 AM Hello,
I've written a DTS to copy selected objects (stored
procs/tables/functions etc - data from tables also) over from a source
database to a destination database. I'm using 'Copy SQL Server Objects Task'
to do the actual transfer. The problem is that I need to get this DTS from
the...more >>
Newbie:Weird DTS problem when exporting to .txt file Posted by Rick Bond at 9/22/2006 7:21:32 AM Hi. I have a simple DTS package set up with a datasource, transform data
(for my query) linking to a destination text. I also have a global
variable of type decimal, which I use a parameter in my query.
If I run my query in QA it works fine or if I replace the parameter with
a hard-coded val...more >>
dts package best place for lots of logic Posted by rachel_c NO[at]SPAM rocketmail.com at 9/22/2006 6:38:25 AM Hi All,
I'm new to dts stuff. I've designed a dts package to create renewed
licences. It loops through a number of files, imports the data into a
temporary table and does a lot of processing on this table to create
new Licence table records, mark licences as renewed and add extra table
entrie...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |