|
|
|
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 Package Challenge!! Posted by Vai2000 at 6/21/2007 4:24:28 PM Hi All, Need to accomplish this in SSIS...if someone can point me the flow
tips or how to proceed would sincerely appreciate it. The OwnerRecord_1 owns
RecordA and RecordB....and so on...the owner record follows the record
Flat File Input
RecordA...........
RecordB..................
OwnerRec...more >>
Can't execute SSIS package with Dtexec on cluster node Posted by EagleBeek at 6/21/2007 8:54:03 AM I have an SSIS pacakge that must be run using the 32-bit version of
dtexec.exe. This is the command line that I use:
"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe"
/SQL \PnL\MarketingAllUploadXLSPIACCosts /Server dwhsql1
Our environment consists of a singe develo...more >>
Dynamic change of Connection parameters in DTS at runtime Posted by Jean at 6/21/2007 5:39:38 AM Hello,
I am currently deciding on what to do in a classic scenario:
I am writing DTS packages that will be executing on the Development
SQL Server and performing various tasks.
Once I am satisfied with the DTS packages, I will migrate them to the
Testing environment and then finally to th...more >>
Filecopy Denied Posted by Peps at 6/21/2007 4:08:44 AM I have a job that needs to copy a file from a network share to the
local server. I'm using a FilesystemObject.Filecopy script and it
works ok when executed under my admin account that has access to the
network share. The problem I'm encountering is when I schedule the
job.
SQL (2K) is running...more >>
OLE DB Providers available within DTS Posted by LittleGlenn at 6/20/2007 8:49:00 AM Within SQL Server 2000 , I am attempting to create a DTS Package to transfer
data from Active Directory to SQL Server. Setting up the SQL Connector is no
problem, but the list of OLE DB Providers does not include the provider for
Active Directory.
Checking the registry under
HKEY_CURR...more >>
How can I get @@ROWCOUNT of a Transform Data Task Posted by Geri Reshef at 6/20/2007 4:18:28 AM I'm importing a text file into a table using the DTS Transform Data
Task.
How can I get the number of the imported records?
The global variable @@ROWCOUNT is equal to 0 in the next step (Execute
SQL Task)..
...more >>
ntext and dts Posted by Jonathan Crawford at 6/19/2007 7:43:13 PM Hi
In SQLServer 2000 is there any way to
transfer ntext data. SO far every method we have tried
has failed
Is it possible
thanks
jc
...more >>
UPDATE package? Posted by Jeff at 6/19/2007 1:49:11 PM Is it possible to have a package (or any other automated
functionality) that will UPDATE a table as opposed to INSERT. This is
something that I have cared to do numerous times but for the life of
me I can never get anywhere with it.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
concatenating data Posted by ITDUDE27 at 6/19/2007 11:11:40 AM
I am concatenating data for the ticket process. I am now joining
to another table (customer_own_Pnumber) for an additional column.
The problem I’m having is data in that table does not always have their
own
part number in that table. So, when I join cust_ID or item_id (which does
...more >>
Execute DTS Package from SQL Server Job problem Posted by Han at 6/19/2007 8:39:01 AM Hi all,
I create a DTS package to import an csv file into 1 table on SQL Server. I
don't have problem to execute the package directly. But I want to schedule
this package to run on specific time during the day, therefore, I create a
job and assign cmd command to run this package via this ...more >>
importing data from ssis with exe file Posted by Bob Yang at 6/18/2007 7:20:34 PM some users need to import the data once a while. instead of running
from the server all the time, I am thinking to create an *.exe tool
for them to run in their own machines. after create SSIS imorting
tool, may I use it to create exe file or is it possible to create and
winform *.exe applicatio...more >>
SQL Server 2000 Import and Export Posted by Joe K. at 6/18/2007 3:45:00 PM
I am using the SQL Server 2000 Import and Export program to copy data from
SQL Server tables to Oracle tables. I have the Import and Export program to
create the Oracle tables. The table names in SQL Server are all lowercase
how can I have the program create the table names in uppercase?
...more >>
How? Programmatically determining the package is failing Posted by Lee Gillie at 6/18/2007 1:11:17 PM If I get some script code to run at the end of a package execute, is
there any way to tell the package is successful or failing at this point
in script? I want to set a subject line for a mail task to SUCCESS or
FAILURE....more >>
How? A task that fires at package completion regardless of success/failure Posted by Lee Gillie at 6/18/2007 1:09:07 PM I see the OnPostExecute event. But how do I catch the one for the
package? Can it be coded "generically" so I can copy it from package to
package as needed?...more >>
program to make changes to multiple DTS packages? Posted by Chris at 6/18/2007 10:51:00 AM Hi,
I am using a 3rd party tool to generate OLAP cubes of our sql database.
We have approximately 100 DTS packages to generate our cube data.
There is a known bug in the interface that you cannot change the SQL server
database account password used to run the DTS packages.
In our company...more >>
Delete an excel worksheet only if it exists, in a dts package Posted by rshivaraman NO[at]SPAM gmail.com at 6/18/2007 8:39:32 AM Hi :
1. I import data into sqlserver, from an excel file, from a worksheet
within it, named 'input_data'
2. then i scrub the data in sqlserver
3. then i export some data into the same excelfile but into another
worksheet named 'output_data'
I have got it working and this is how i am doing ...more >>
DTS uploading Posted by Tiffany at 6/18/2007 1:43:00 AM Hi
Wanted to upload a text file to SQL table. one of the columns has data like
below
MDD - Inquiry abt showroom / dealers
MPFW - Inq. about Product Features & Specification
MRPC - Request For Product Catalogue / Broucher
When transferring the data from the text file to SQL table, i wa...more >>
SetComponentProperty("Name"... Posted by Sebastian Ciesielski at 6/18/2007 12:00:00 AM Hello,
I try to prepare SSIS package with application written in C#,
but I noticed problem with following code:
CManagedComponentWrapper instance1 = source.Instantiate();
instance1.ProvideComponentProperties();
source.RuntimeConnectionCollection[0].ConnectionManagerID =
pakiet.Connect...more >>
dts Posted by Wendy Elizabeth at 6/17/2007 9:07:01 PM I would like to know how to automate the following two processes with excel:
1. I would like to take data that is obtained from sql server 2000 queries
results and load the detail data onto excel spreadsheets.
2. I would also like to take data that is obtained from sql server 2000
query re...more >>
SQL 2005 integration with an asp / asp.net application on the GUI Posted by iweb at 6/16/2007 3:40:00 AM 1) We need to give a hyperlink from our application to MS SQL Server
Reporting Services, is this possible? Any idea? So from the client side
browsers maybe via the internet or on a LAN on a click it should open the
Reporting services.
2) We also need to give a hyperlink from our applicati...more >>
Data overflow problem Posted by Jack at 6/15/2007 2:39:01 PM Hi,
I got a Access database and I need to import a table to sql server. I am
using the DTS feature to import the table. However, the import is failing
with a message that column 43 ('shipdue', DBTYPE_DBTIMESTAMP) status 6: Data
overflow
Invalid character for cast specificatioin.
In Access t...more >>
select specific date from Excel using SSIS package variable Posted by bhorwatt at 6/15/2007 8:29:02 AM I have the following selection string in an SSIS package that selects a
specific date from an Excel Connection source:
SELECT FMonth, Plan, ACDCalls
FROM [Data$]
WHERE (FMonth =#5/1/2007#)
I want to use a variable within the package that is in the format of
20070501. H...more >>
Copy DTS to new server Posted by Jeff Boyce at 6/15/2007 8:03:50 AM SQL-Server 2000.
Independent (isolated) SQL-Server installations on laptop and on separate
network.
I've only been able to find ways to transfer a DTS package from one server
to another on the same network.
How do I transfer/copy a DTS package I have running on my (independent)
laptop...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |