|
|
|
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 package loop execution Posted by gremlin321 at 7/20/2007 2:16:01 PM i have a table that contains historical data. i need to process records by
business date, i.e. run package for date 1, then for date 2 etc. any
suggestions on how to approach this?...more >>
Optional Package run in DTS Posted by ic0n67 NO[at]SPAM gmail.com at 7/20/2007 10:15:29 AM Hello everyone.
I have a package in DTS that I am tryinig to work with. We have a few
queries that will export the same exact table to a text file. I am
trying to make it so we can pull a previously created text file from a
central "CommonFile" folder. In this package I have a Execute Pack...more >>
passing variable in sql2005 package Posted by Daniel Vakil at 7/20/2007 6:18:03 AM hi, how can i get into the package the user.variable i passed by the command
line :
DTEXEC /SQL "\aaa\packages" /SERVER SQL2005SERVER /SET
"\Package.Variables[User::myvar].Properties[Value]";5849
i write this activeX script
a = Ctype(Dts.Variables.[User::myvar].Value, String) and also
a...more >>
executing package while passing user variables in SQL2005 Posted by Daniel Vakil at 7/20/2007 1:44:00 AM hi, in sql2000 I used "dtsrun" to run a DTS package from a stored procedure
and used the /A parameter for passing user variables. How can i use the
"SSIS" to build into the SQL2005 server a new package and run it from a
stored procedure while passing user variables. thanks....more >>
Copy Database Wizard (build 1399 OK -- build 3042 broken) Posted by Ulyssit GmbH - Peter Guenther at 7/19/2007 4:34:07 PM Hello,
Currently we are a SQL-Server 2005 Standard Edition SP2 (build 3042)
and wish to copy a datebase using the Copy Database Wizard. Unfortunately,
this does not work on build 3042
we receive the follow error. And this error only occurs when we try to copy
a database with more than 500 (...more >>
SQL server200 DTS package Posted by sush at 7/18/2007 12:44:41 PM what difference does it make if want to execute t-sql statements dritectly in the process task icon in the dts rather than creating a Stored procedure and executing it
in the process task icon
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com...more >>
Very New to DTS - Need Help Please.. Posted by sweety at 7/18/2007 5:44:03 AM Hi,
I've a file which I'll download from my client's site and save it on my hard
disk, and import it to the same database table every friday.
I want to make this process automatic. So, I went online and searched on
this issue.
And I'm pretty much convinced that DTS could do this. I went and ...more >>
DTS SQL select issue Posted by Matt Day at 7/18/2007 12:00:00 AM I am using a DTS package to update some tables in an online database and
have run into trouble with one of the tasks.
The SELECT I'm using is;
SELECT DISTINCT d.ITEMRELATION, c.CONFIGID, d.FROMDATE, d.TODATE,
d.ACCOUNTCODE, d.ACCOUNTRELATION, d.AMOUNT, u.TXT
FROM PRICEDISCTABLE AS...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SSIS 2005 Configurations Posted by mgale1 at 7/17/2007 9:10:01 AM Hello,
I am having a bit of trouble with SSIS Configurations.
- In BIDS, I have added a configuration file and specified the properties I
want to expose.
- When I build the project, I get the standard bin\deployment folder which
contains the package file (.dtsx), the configuration file (....more >>
Change of date format Posted by Tiffany at 7/17/2007 1:32:04 AM Hi,
Every month, i need to upload a set of raw data to SQL. the raw data format
is mm/dd/yyyy 10:59:00 AM. I want to standardise the date format in SQL to
only mm/dd/yyyy without any time indication. How to change the date format in
the SQK to mm/dd/yyyy and how to convert the raw data date...more >>
Deleting data from vfp table Posted by carloshgo via SQLMonster.com at 7/16/2007 4:09:08 PM Hello!
I'm Creating a DTS to export information into a VFP table but first a need to
delete all existing data from VFP table
I'm using a conecction "Microsoft OLE DB Provider for Visual Fox Pro" between
SQL server 2000 and my VFP free table called "ValidStores.dbf" and i can view
data from ...more >>
Data conversion with DTS package Posted by Han at 7/16/2007 2:00:04 PM Hi,
I try to import a text file into sql server table which has combination of
string, int, float, datetime fields. Some how I keep getting error with data
conversion from String to Int, String to Float, String to DateTime fields.
How can I overcome this problem? I though SQL handles thi...more >>
SSIS Packages Posted by S at 7/16/2007 10:08:33 AM It seems to me that SSIS packages changed creately fromt he DTS that I
used to know.
So my question will seem rather simple.
How do I get a variable into an sql query that transfer data from 1
database to another.
Old Query would be:
Select FirstName, LastName FROM Person WHERE Locatio...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |