| |
by: Otto Blomqvist |
last post by:
Hello !
I have two tables (which contains individual months' data). One of
them contains 500 thousand records and the other one about 40k, 8
columns. When I do a simple query on them individually it takes
milli-seconds to complete (see gory details below). For some querys I
want to include data from multiple months so I created a view using...
|
by: stant |
last post by:
I am trying to call a mainframe cobol DB2 Stored Procedure from an SSIS 2005 SQL Task in BIDS. I believe that privileges and the number of parameters (6) are fine. I've tried casting and still have no luck. The error is SQL0440N. I am running with DB2 Client 8.2.4. The sql call in BIDS looks like...
call ODW.ODWCY002 ('TN',cast...
|
by: AMAN |
last post by:
Hi all,
I am a newbie to SSIS.Need a solution to couple of issues I am
currently facing while developing ETL in SSIS
1) Under SSIS Package Folder I have defined mappings for 17 dimensions.
1st Dimension say Account has been Set up as a startup object.
Now when I run the package ir runs only my account dimension and loads
the target,other...
|
by: SQLNewbie |
last post by:
Hi all,
New to SQL Server - trying to create an SSIS package that will look for
and import a series of Visual Foxpro tables (.DBFs) when they appear in
a folder.
The tables are/can be all different fields, field widths, etc. With
quite a bit of overlap though.
The end result should be table "ABC.DBF" is pulled into SQL Server as
|
by: Eric |
last post by:
In MS Excel, the ability exists to run a "web query." This function
is accessed via the data menu's import external data option. The web
query wizard accepts a URL address, and then is able to import the
data from that address into an excel worksheet.
What I would like to do is use SSIS to import data from the same web
site. In other...
|
| |
by: fboweb.com |
last post by:
Hey there! I have a DTS import package from an old SQL server that
takes flat text files, does some munging on the columns using ActiveX
scripts and imports those flat files to various tables.
The package itself is rather tedious because it does this munging on
a
number of large files with a number of different fields.
When I bring...
|
by: rmsterling |
last post by:
All,
Subject : SQL Server 2005 SSIS Script Help - XML Secure Pull in to DB table
I was wondering if any of you could help me with something.....
I want to design a SSIS script that will pull XML data from a secure HTTP
website direct in to a local database table.
I have had no training on SQL Server 2005 SSIS. I have a reasonable
|
by: gelangov |
last post by:
I have 2 variables, one is the column name of the table and the other
one is the table name and I need to write this in the "Execute SQL
task" of a "For each loop" container in a ssis package like this:
Truncate table <tableName>
Insert into <tableName>
Exec (' select from '+ ?)
It gives me error message when I try run the ssis. ...
|
by: jags_32 |
last post by:
We have spent days trying to perform a proof of concept and I am
dissappointed with SSIS to say the least. We are trying to connect and
fetch data from a Double Byte Progress database and the "DataReader
Source" using a ADO .NET ODBC provider does not work! I understand
that SSIS is a totally rewritten version of DTS. What annoys me is
that...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
|
53
