|
|
|
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 Import multiple mdb files to SQL Server issue: Please Help... Posted by NT at 4/13/2007 4:40:01 PM Hi All,
I have about 100+ mdb files with the same table structure design; need to be
imported into SQL Server. They are in the same directory but separated
sub-folders (ex: d:\MTS\A1\*.mdb files and d:\MTS\A2\*.mdb
files....d:\MTS\A...n\*mdb files)
I've created the DTS package to import but...more >>
Executing dtsrun from a store procedure Posted by BigO at 4/13/2007 10:28:01 AM I am trying to execute a DTS Package from within a stored procedure,
however the Execute statement hangs while running the debugger.
The sql is EXECUTE @SP_Return = master.dbo.xp_cmdshell 'DTSRun /E /
SBIGO /NPFW Data Load', NO_OUTPUT
The debugger hangs, SQL Query Analyser does not respond aft...more >>
Regarding execute restore database in dts Posted by Iter at 4/13/2007 7:20:00 AM Hi Guys,
I want to design a dts that has two tasks, one task is retrieve backup file
name in the global variable, and second task get that file name, then restore
database from that file. I don't know which task I can use in send task that
I can get that file name from globle variable then ex...more >>
exec sql task within a loop Posted by madan at 4/12/2007 7:35:19 PM I have a package with 3 sql execution tasks and a active x script. The
first sql execution task has a rowset value as the output parameter
and in my activex script im trying to loop through the results and
execute the sql tasks 2 and 3 ... this is what im trying to
accomplish...
Dim oRS
Set ...more >>
Merge Join Posted by JMMB at 4/12/2007 6:02:03 AM Hi,
I'm using a Merge Join with two OLEDB data sources to output the matching
records on a specific key to a table on the database.
I also need to record the records that DON'T match to a second table. How
can I do that?
Thanks very much,
Marcelo.
...more >>
error al ejecutar package dtsx. Posted by xisconotario NO[at]SPAM gmail.com at 4/12/2007 12:01:10 AM Hola, he creado un package dtsx y lo ejecuto en el dise=F1ador y me
funciona correctamente, me hace las transformaciones pertinentes y me
introduce los datos en la BD.
Lo ejecute desde una aspx con las instrucciones:
string pkgLocation;
Microsoft.SqlServer.Dts.Runtime.Package pkg;
...more >>
using store procedures with temp tables on dts Posted by Roy Goldhammer at 4/11/2007 6:50:37 PM Hello there
I have sql server 2000 SP4
I need to export one of my store procedures who has temporary tables in it
and it gives me an error.
Is there a way to do that?
...more >>
DTS and MSDE Posted by jim at 4/11/2007 3:06:01 PM Hello,
I have vb (6.0) app that attempts to execute a couple of dts packages. The
pkg's merely does some data retrieval and pumps the data into a text file
(.dat). The app runs fine on the machine that have sql server (7.0)
installed. However, on the machine w/ MSDE the app appears to be ex...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Two DTS packages Posted by qjlee at 4/10/2007 8:40:01 PM I have two DTS packages A and B. Is there a way I can set up so that I can
schedule for B to run automatically after A successfully completed and once B
is completed, send out a notification email.
Thanks,k...more >>
Configuring Destination Database in Transform Task Posted by andrew.cann NO[at]SPAM mater.org.au at 4/10/2007 7:46:51 PM Hi
Is is possible to configure the destination database in a
transformation task? I have seen a few posts on this subject, but I
havnt seen any solutions. I am currently using a dynamic properties
task to assign the catelog (database) value, but the transformation
task continues to use the ...more >>
Schedule a DTS Package with a Password Posted by qjlee at 4/10/2007 6:48:01 PM Hi,
I have a DTS package that requires a password to run, e.g. the password is
test.
How can I schedule it to run automatically?
Thanks,
...more >>
Passing parameters to stored procedure in ole db source Posted by wdudek at 4/10/2007 2:04:03 PM I am trying to call a stored procedure as the sql command in the ole db
source data task component. This works fine if I hard code the parameter
value. However when I switch the parameter value to be a variable, the column
mappings dissapear. What do I need to do in order to maintain the colum...more >>
Lookup Transformation Posted by christy at 4/10/2007 11:28:03 AM I have a source table Product and a lookup table Class based on
Product.ClassID = Class.ClassID. I need ClassName from Class table in the
output.
There are records in the Product table that don't have any class assigned
yet. I need to include those no-matchings in the output (more of a left...more >>
Execute SSIS package remotely and get notified at the end Posted by oliviers at 4/10/2007 4:41:26 AM Hi,
I'm trying to find a way to execute a package remotely and then to
notify the users that the execution is over.
I created a SQL Agent job I'm starting thru a SP call.
The problem is that the execution is asynchronous.
How could I notify the user that the execution of the package is over?
...more >>
Destination column value from Global variable Posted by mkhan2001 NO[at]SPAM gmail.com at 4/9/2007 9:13:37 PM Hi,
I am learning SSIS and trying to create a DTS package for importing
data from Excel Source to OLE DB Destination. It works fine if I have
all columns in the Excel Source match exactly with columns in D/B
table. But I have few columns in the D/B table, Fkey ids which are not
available in t...more >>
How to generate a summary report for SSIS package? Posted by nkw at 4/9/2007 8:40:01 AM I have a package using foreach loop to load flat files. Some of the
files/transfer may fail for different reasons at different tasks. I want to
have a summary report shows the succeeded and failed files at the end (maybe
using sending mail task to send).
What's the best way to generate the ...more >>
Migrating back to SQL Server2000 Posted by Boopathi at 4/9/2007 7:54:01 AM Hi,
I have a DataBase in SQL Server 2005 which is migrated from SQL Server 2000.
I want to move back it to SQL 2000. Is there any steps that I need to take
care?
Thanks & Regards,
Boopathi.P...more >>
Upsizing Access Queries to SQLExpress Posted by dotNET learner at 4/8/2007 9:10:42 PM I could successfully upsize all TABLES of an Access2002 database to
SQLEXPRESS.
How can I export/upsize Access Queries (which are many and useful)??
Newbie seeks help.
Thanks !
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |