|
|
|
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 SSIS job problem Posted by Sienna at 12/7/2006 3:17:49 PM I wrote and deployed an SSIS package as a file system package (SQLServer
2005). I tried scheduling the package to run as a job step using SQL Agent
Service Account with Windows Authentication and I have admin rights. It
fails. I have tried a lot of things to get this job to run the package ...more >>
SSIS Deploy Method file .SSISDeploymentManifest faulty Posted by Slice at 12/7/2006 10:11:42 AM I used the file system right-click, Deploy menu choice on the file
..\bin\deployment\<prjName>.SSISDeploymentManifest and 4 of the 13 .dtsx
files were not published into the MSDB database although the log file
generated says otherwise.
No configuration files were involved; authored .dtsx in fi...more >>
Copy data from 2005 to 2000 Posted by Will at 12/7/2006 8:51:19 AM We have a production database on a SQL 2005 server. I need a copy of
the data and the schema (if possible) to be copied to a SQL 2000 server
we use for development and testing. I asked my SQL DBA to set up a DTS
Job to do this every day at 4am, but my SQL DBA says you can't do this
(incompatib...more >>
importing space delimited text file Posted by jesbuddy07 at 12/6/2006 11:04:01 AM i've been looking on this subject in this group with no luck.
i've been trying to import a text file which has multiple space
delimited column to a SQL server 2000.
i can't seem to find any answer on this subject. i tried typing space
on the delimiter field, but i get
"error source: microso...more >>
Data conversion failed while converting column "officename" (70) to column "officename" (250). Posted by IanO at 12/6/2006 7:39:57 AM Please tell me how I can GLOBALY change the default error handling to
just keep going.
It is far more important that I get the good rows then stop on one bad
one.
This error is reported from the Data Flow Control Flat File Source.
For some time, I have been changing fail on error to ignore ...more >>
assigning source file at runtime Posted by san at 12/6/2006 2:00:07 AM hi,
i have made a package in SQL SERVER 2000 and then execute it from
vb.net
the source file is .txt file and the destination is sql table.
now the source file's path is to be given at runtime thru vb.net code.
i used the following code:
Dim dtsImport1 As New DTS.Package2
...more >>
Can't export to fixed-format text on workstation Posted by JXStern at 12/5/2006 10:51:48 PM It has something to do with my workstation config, same package builds
and runs fine on other boxes.
Breaks when I try to build it on my workstation. Simple connection to
database, text file destination, straight-thru transform. Problem is
the destination for some reason lists no fields, and...more >>
Global Variable value cannot update in ActiveX Script Task Posted by too.changmian NO[at]SPAM gmail.com at 12/5/2006 6:51:40 PM Hi all,
I want to call stored procedure from my DTS, after execute the SQL , i
want to pass the global variable to ActiveX Script. However, the global
variable in ActiveX Script only hold the default value
Here is my stored procedure:
CREATE PROCEDURE sp_test123
@TotalCountSum int OUTPUT...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
In what table will I find my packages? Posted by IanO at 12/5/2006 8:01:47 AM When I connect to Intergration Services, expand msdb folders, I can see
my packages.
However when use the database as in:
use msdb
go
Select top 11 *
from dbo.sysdtspackagefolders90
Select top 11 *
from dbo.sysdtspackages
I can see the folders from the first query but cannot see...more >>
Inserting 20 Million Rows to Oracle Posted by TM at 12/4/2006 2:39:04 PM Here is a good question for you senior DBAs.
You have to DTS 20 million rows nightly from SQL 2000 to Oracle 9.2.0.
How would you do it?
Here is what I did and some timings.
20 million rows.
SQL Server DTS using ODBC or OLE DB [took hours]
..csv to Oracle using ODBC [took hours]
SQL ...more >>
Looping through datasource using Dynamic Properties task Posted by alex.barvenov NO[at]SPAM gmail.com at 12/4/2006 2:37:59 PM Hi,
I have read hard through both SQLDTS.com and this forum but still can't
make it work together :).
My problem is trivial.
I need to transfer data from a number of identical MS Access mdb
databases into an MS SQL Server db via DTS. I need to open the first
mdb, transfer data, go to the s...more >>
"File Connection Manager" for package logging Posted by IanO at 12/4/2006 1:09:07 PM When I enabled logging on a package, I was asked to give a unc path and
filename.
My options were (and still are)
Create File
Existing file
Create Folder
Existing Folder
Ocassionally, I clean out the log files directory. So I option I look
for is:
If the file is there, append to it; if no...more >>
DTS bulk insert error Posted by Kalyan at 12/4/2006 12:16:00 PM Hi
I am trying to import a table from SQL Server 2000 (it got about 40 Millions
rows) to SQL Server 2005 table, I am getting this error after transforming
for about 1 hr.
I used simple data flow task with default settings.
Any help
[SQL Server Destination [283]] Error: An OLE DB err...more >>
Dynamic File Definition for Source Files Posted by Jen Espana at 12/4/2006 7:30:00 AM Hi all,
I am hoping that someone out there might be able to help me with a
requirement we have from our client.
We want to use SSIS to import our client's data into their database. The
issue is that the source file's column definitions may change. (For example,
new columns may be added ...more >>
copy sql database problems Posted by chanix yahoo at 12/3/2006 6:03:55 PM hi!
i'm trying to copy a database from one server to another. but still
problems persist. here are the details of my servers.
Server A (source)
OS - Windows 2000 Advanced Server
SQL - SQL 2000 Enterprise Edition, Service Pack 4
Server B (destination)
OS - Windows 2003 Server Enterprise ...more >>
SSIS "The connection has been disabled" error Posted by rhjDBA at 12/2/2006 3:36:00 PM I created a custom script source component to pull data from a dirty
pervasive 2000i DB service pack4.
Heres the problem my component will pull 425 rows of data but it will do
this only if I set my deffaultBufferMaxRows property to a small number like
17. It will not pull more than 425 it h...more >>
How was the package started? Posted by GunnarKarlsson at 12/2/2006 9:09:00 AM Is it possible in a script task to determine if the package was started by a
call from a parent package or directly from DTExec?
--
...more >>
Build for Production Posted by IanO at 12/1/2006 1:51:42 PM Maybe because its Friday afternoon but I've been looking for a
definitive statement on the method of specifying that this next build
will be for Production and all the Debug overhead will be deleted from
the result.
It has been decided that we will run our production jobs from the MSDB
databa...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |