|
|
|
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 New file and file date Posted by qjlee at 4/28/2007 11:56:02 AM I have folder called TEST and is located in C drive. Every month, a new file
with the name IMMYY.txt will be put in there (MM---Month, YY---year). How
can i create a SSIS package to check to see whether there is any new file in
TEST folder and, if there is, insert into the filemonth field in...more >>
build command for SSIS project Posted by yongli at 4/27/2007 2:24:01 PM Hi,
Does everyone know if there is command line to build a SSIS project
equvilent to the build menu in the visual studio?
Thanks,...more >>
Drop and re-create destination table (?????) Posted by Dan at 4/27/2007 1:40:02 PM I am trying to do something that took no time in SQL 2000, which appears to
be way more complex in 2005.
I have added a column to a table(attribute) and trying to push this table
out to another server using DTS. Well, when I select the table in the table
list, and go to "Edit Mappings", th...more >>
SSIS Variables Carry-Over Across Scope Posted by Lawrence at 4/27/2007 7:24:03 AM If I assign variable "LoopCount" in the ReadWriteVariables property of a
Script Task, it should carry over to the Loop Container Scope afterwards
right?
Here are the steps I am using.
1. In Script Task 1, assign
Dts.Variables("LoopCount").Value = 3
2. Assign variable "LoopCount" to R...more >>
modifying dts code via a program Posted by 906507N at 4/27/2007 3:41:31 AM Hi,
under sql server 2000, do you know how I can access via vbscript to the dts
code and make programmatically some changes ? what are the usefull api's ?
for example, I want to change database properties
of course, I can write the dts the correct way in order to handle
different se...more >>
breakpoints - Unable to step. Not implemented Posted by adolf garlic at 4/27/2007 12:58:02 AM Number of articles on web showing how to implement breakpoints in SSIS
=zillions
Number of articles on web showing how to 'step into'
=bugger all
Am I being a bit thick?
I'm used to hitting F11 to move on in VS.net
It hits the breakpoint but then what?
Either I can carry on running ...more >>
Execute Legacy DTS in SQL 2005 Programmatically? Posted by Steve Bidondo at 4/26/2007 11:28:02 PM Hi All,
I'm getting an environment ready to test SQL 2000 DTS packages running in
SQL 2005 (under legacy..DTS). I will be calling these from VB code attached
to an ASP.NET 2.0 app. Before investing too much time...
1) Is it possible to call DTS packages from .NET using SQL 2005?
2) If...more >>
SSIS Variables Error Posted by Lawrence at 4/26/2007 5:14:02 PM Hello,
I received this error when processing SSIS Package.
Error: A deadlock was detected while trying to lock variables
"User::LoopCount" for read/write access. A lock cannot be acquired after 16
attempts. The locks timed out.
I declared the following my variable also in the code belo...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to export from SQL Server to multi-record text file Posted by Woodberg at 4/26/2007 3:49:45 PM I've got a project to export data from a SQL Server and get it into a text
file which has multiple records. Basically, the output file has a 3
records; a file record, a header record and a detail record. It has to be
configured like below:
File Record
Header 1
Detail 1
...more >>
execute dts from trigger Posted by Rick at 4/26/2007 8:44:03 AM I have a situation where I have a remote system that I need a File from.
I have created a database link from the oracle system to sql server.
When oracle generates the file it then writes a row to a indicatator table.
I need to then execute a dts job to ftp the file from the remote server to
sq...more >>
excel import error 0xC020801C "cannot acquire connection from conn Posted by adolf garlic at 4/26/2007 7:54:03 AM I have inherited a package and am struggling to get it working.
It is failing at the point of trying to open an XLS.
I have tested the connection and am able to preview the data ok.
(I am running in BIDS/VS.NET)
When I try executing the task I receive the following error:
Error: 0xC020801...more >>
sleep function in DTS Posted by grey at 4/26/2007 12:00:00 AM i am writing DTS in sql server 2000. i have to write the delay, such as
delay for 1 minutes before taking to next step. i have to use WScript.sleep
(60000) to do the delay, but it prompted the error.
Object required: 'Wscript'
so how to do the delay in sql server 2000 DTS??
...more >>
Foreach Loop Container - Filter for Multiple Files. Posted by Sachin Chavan at 4/25/2007 8:46:02 AM Hi,
Can I hv filters for Multiple Files in the ForEach - File Enumerator of SSIS.
Basically, what I am trying to do is I am Looping thro a Directory for 2
Kinds of CSV Files one has extn '.add' n the other has extn '.upd'.
Now if I try to include filter for both of these files by specifying...more >>
Drop Table and Recreate vrs Delete existing data Posted by Tom Jones PA at 4/25/2007 4:38:03 AM Can anyone tell me if there is any significant difference in speed using drop
and recreate table vrs delete rows in existing table on a table with a large
number of records?
...more >>
How to see migrated dts from sql 2000 to 2005 Posted by freddie at 4/24/2007 11:44:58 AM Hi!
I used sql server 2005 to emigrate a dts from 2000. But I cannot to see the
dts in 2005. SQL Server 2005 said the migration was successfully.
Why I can't see the DTS in SQL Server 2005.?
Thanks,
Freddie
...more >>
SQL 2005 DTS, package stops loading and gives dts not installed error Posted by B.D.Osborn NO[at]SPAM googlemail.com at 4/24/2007 9:47:12 AM hi,
i have several dts packages from an old sql 2000 install that i
upgraded to sql 2005, if i install the client tools on windows 2000,
then install the additional DTS components i can open the old DTS
packages sucessfully,
if i install the client tools and the dts components on a window...more >>
SSIS and VB.net - Can't see DTS stored Procs. Posted by Kingsley. at 4/24/2007 8:24:03 AM I've created a number of DTS procedures using the Business Int. Dev. Studio,
and can view these in the Server Management Studio Object Explorer
(Integration Services – Stored Packages – MSDB). However when I try to
access these from VB.NET 2005 as follows;
Dim oPkg As DTS.Package2
...more >>
SSIS flat file loading - data type conversion Posted by nkw at 4/24/2007 8:06:00 AM It seems I can do the type conversion in two place:
1. The advanced editor for flat file source => Input and output properties.
And I can set the output columns data type properties there.
2. Using a Data conversion box in Data flow transformation.
Any difference between these two? Which ...more >>
Where should I run the package from ? Posted by CraigHB at 4/24/2007 6:12:01 AM I want to move SQL Server 2005 data from server1 to server2 using SSIS.
(1) If I run the SSIS package on server3, will that take longer than if I
run it from server1 or server2 ?
(2) If I run the SSIS package on server3, will the data have to go via
server3 on its way from server1 to serv...more >>
BlobColumn.AddBlobData causes SSIS to hang Posted by SpsApprentice at 4/24/2007 6:08:03 AM (SQL Server 2005 Dev on Windows XP Pro SP2)
When I use a script transformation to put data into a DT_IMAGE column, my
package hangs. It doesn't seem to matter what data I write, so I was able to
reduce the non-working example to this:
Public Overrides Sub Input0_ProcessInputRow(ByVal R...more >>
Data Flow Task copying data from one table directly to another is very very slow Posted by weelin at 4/24/2007 4:20:37 AM Hi there,
I have a simple Data Flow Task in my package (amongst other things)
that simply copies data from a staging table to an archive table. The
archive table is a copy of the staging table (at the moment, including
the clustered primary key).
Copying across 36,000 rows has literally ta...more >>
Is it possible to filter recordset data to use in an ADO ForEach container? Posted by weelin at 4/24/2007 2:09:43 AM Hi there, I was wondering whether it is possible to return a
recordset and then filter it when using it in an ADO ForEach
container? So rather than using 2 recordset objects which hold
similar datasets with different WHERE clauses and sending these to two
separate ForEach ADO containers, can y...more >>
Obtain Previously Executed Task Name Posted by OG at 4/23/2007 7:56:57 PM Hello,
I'm wondering if it's possible to somehow dynamically obtain the
name the task that was run previous to the current task. The reason I
ask is that I'm hoping to create a single "Execute SQL Task", that
logs errors to a table via a stored procedure. If I were able to
obtain the name...more >>
SSIS File not being populated Posted by Just Me at 4/23/2007 7:37:07 PM I have been working on recreating a dts package in ssis for 2 weeks. It is ridiculous. I finally got sql server 2005 to run the package successfully. With half my hair left, I realized the package does not update the flat file destination. The destination is a .dat file in a directory off the c driv...more >>
Problem in loading data from excel to SqlServer 2000 Posted by rahulcheeku NO[at]SPAM gmail.com at 4/23/2007 2:36:51 PM Hi,
I am building a DTS package in Sql Server 2000. Data source is an
excel file and destination is Sql Server 2000. This package runs
monthly and loads the data into database. But evey month the number of
columns in the source excel change. Now i am trying to get the number
of columns from the...more >>
Newbie to DTS Posted by wnfisba at 4/23/2007 9:44:01 AM I have developed my DTS into separate packages. Is there any way to bring all
these sub packages together to create the final package???
Thanks in advance for your help.
wnfisba...more >>
Sending email from DTS in 2005 Posted by Emma at 4/23/2007 6:50:04 AM I am executing my 2000 DTS packages in 2005 and I am getting the following
error message: could not find stored procedure 'master.dbo.xp_smtp_sendmail'.
Every other steps worked fine.
Thanks,
Emma...more >>
How to save an dtsx file to sql server? Posted by nkw at 4/22/2007 1:04:01 PM I have dtsx files and I want to save it on SQL server. How to do it? Thanks....more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |