Using SSIS To Pull From ODBC Drivers?

Jan 3, 2008

Hi all,

I've been tasked to do some investigation at my workplace as to the best way to move forward with changing from our SQL 2000 DTS' to SQL 2005 SSIS packages.

Our main issue at the minute seems to be that we are using ODBC drivers to pull many of the raw tables which we then manipulate into our own SQL Server tables.

I've been looking about and am I right in saying there is an issue with this in SQL 2005?

Also, I've been looking for some Tutorials to help me on this, would anyone be able to push me in the right direction of any good tutorials that would help me in fixing these issues?

Cheers

View 3 Replies


ADVERTISEMENT

MySql SSIS Hangs With ODBC Drivers

Mar 2, 2006

Hi, we are writting a SQL Server Integration Services package to import data from a MySql database to a Sql Database.

We are using ODBC 3.51 Drivers to connect to the MySql Database in SSIS. The package runs perfectly in design mode. When we schedule the package to run, the package seems to hang about 1/3 of the times.

What can this be. We used to the package and ran it from a Sql Server 2005 to a Sql Server 2005 database. This setup works perfectly. When i'm doing MySql to Sql Server 2005, 1/3 of the times, it does not work.

Can anyone help me with this?

Giovan Gentile
Ayuda Media Systems

View 5 Replies View Related

ODBC Drivers

Jan 28, 2000

Hi,

I have an ODBC question. They say that to use SQL server 7.0 'tools', one must use ODBC 3.70 drivers. Is there anywhere where I can find a list of these 'tools' that will need these drivers?

Thanks
Sach

View 1 Replies View Related

Need Help For ODBC Drivers

Jan 11, 2008

Experts,

Will 32-bit ODBC Drivers work in 64- bit machine? I have already installed 32-bit ODBC drivers in 64-bit machine so i wanna make sure all applications work fine.

ALSO, Where can i get to download ODBC Drivers for
1) Oracle in Orahome 92
2)Sybase SQL Anywhere 5.0
3) Informix 3.8 32 bit
4) openlink

Is there any 64-bit drivers available for above ODBC Drivers?
PLease Help.Thanks

View 1 Replies View Related

ODBC Drivers

Jan 30, 2008

Okay, this is a weird question/problem. I have a 64 bit database server running on 64 bit Windows. This is just fine until I moved a 32 bit database over to it. My DB is trying to get some reporting to work and discovered that there are no ODBC drivers for Excel on this new 64 bit box. Are there 64 bit drivers for MS Excel? And access for that matter? If so, where are they?

Thanks.

View 4 Replies View Related

SQL Server ODBC Drivers

Nov 17, 2000

I have a lot of client machines that do not have the SQL Server ODBC driver installed. Without having to install SQL Server client on their computers, I'd much prefer to just install the driver itself. Where on earth do I get it? The microsoft website is about the most confusing site when it comes to looking for driver downloads.

View 2 Replies View Related

ODBC And SQL Server Drivers For 7.0

Oct 5, 1999

Hello,
We're upgrading to SQL Server 7.0 and need to update all our clients with the latest version of the ODBC and SQL Server Drivers. Can someone tell
how to update just these drivers? We tried to use the latest MDAC executable, but it broke applications on at least one client, so we were hoping
to narrow it down to just ODBC and SQL Server.
Thanks,
Dan Holland

dth@qad.com

View 1 Replies View Related

Missing ODBC Drivers - Please Help!!

Nov 28, 2006

Hi all

For some reason, my Excel / Access drivers have disappeared from the list of available data sources when running the Import wizard or when trying to create a dts package. They are installed on the machine as I can see them through the ODBC Administrator. I have googled extensively, found some posts relating to TimeSlips (not relevant as not installed), re-installing MDAC.

Having done all the relevant stuff (updating to latest MDAC), still not coming up. Installed SQL 2005 Management Studio thinking that may help. Still nothing.Can someone please give me some advice, APART FROM RE-INSTALLING OS.

How does Import wizard pickup the available drivers, any registry settings...? Currently running XP SP2 with all the latest updates.

Need to get data uploaded to customer site from Excel spreadsheet. So any help / advice would be greatly appreciated!

TIA

Regan

View 1 Replies View Related

ODBC Drivers Error '80040e4d'

Jan 23, 2001

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''

How to fix this error...

View 1 Replies View Related

Latest ODBC And SQL Server Drivers For SQL 6.5

Mar 22, 2000

What are the Latest ODBC and SQL Server Drivers for SQL 6.5? How can I upgrade them?

By the way, IS IT ABSOLUTELY NECESSARY to reboot the machine after application of a SQL Server service pack? (There is this dispute going on at my co.)

View 1 Replies View Related

ODBC And SQL Server Drivers For 2000

Jun 8, 2001

Hello,
We're upgrading to SQL Server 2000 and need to update all our clients with the latest version of the ODBC and SQL Server Drivers. Can someone tell
How do I upgrade the ODBC driver so that they can connected to SQL 2000.
The client pc's have an older version of ODBC drivers which supports Sql 7.0 Which dll do I need ? ? Where do I get it? Does it have on sql 2000 cd?

Thanks

Priti

View 1 Replies View Related

ODBC And SQL Server Drivers For 2000

Sep 5, 2001

Hello,

We're upgrading to SQL Server 2000 and need to update all our clients with the latest version of the ODBC and SQL Server Drivers. Can someone tell
after updating the ODBC driver to SQL 2000 would it support SQL Server 7.0 ?

Thanks

Sejal

View 1 Replies View Related

Microsoft Ole Db Provider For Odbc Drivers

Oct 18, 2007

I'm not able to see microsoft ole db provider for odbc drivers on sql server 2005. Anyone know which driver I should install to see it?
I'm trying to create a linked server from as400 to SS2K5.




http://www.sqlserverstudy.com

View 2 Replies View Related

How Do I Reinstall The SQL Server ODBC Drivers?

Jul 23, 2005

They are corrupt. I cannot get the odbc driver applet for sql serverto open when I click add and I cannot configure any existing ones. Andthe usage of the drivers fail.Other ODBC drivers work.Does anyone know how to reinstall the SQL Server set of ODBC drivers?MDAC wouldn't install, said it was already at current level.Thanks for any ideas.

View 2 Replies View Related

Microsoft OLE DB Provider For ODBC Drivers Error '

May 21, 2007

Hi guys

I wanna display the compname [in competencies tbl], firstname & surname [in users tbl], position level [in positions tbl] and userlevel [in compuser tbl] but i get the ff error msg

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'CompUser' does not match with a table name or alias name used in the query.

My code:

SELECT compname, firstname,surname ,level AS positionlevel
FROM positions, compuser, users A, comppos
INNER JOIN Competencies
ON comppos.Compid = competencies.Compid
RIGHT JOIN Users
ON CompUser.UserID = Users.UserID
WHERE Users.UserID = '999209'
OR Users.UserID = 'helpdesk1'
OR Users.UserID = '999339'
OR Users.UserID = 'helpdesk5'
ORDER BY CompName

Pls kindly help
Noks

View 1 Replies View Related

How Do You Reinstalling ODBC Drivers In Vista Business?

Oct 30, 2007

How do you reinstalling ODBC drivers in vista business?

I have installed SQL 2005 Express & SQL Server management Studio Express, with SP2

However, the required driver "SQL Server" is not showing up in the list when trying to add a datasource in System DSN.

Can someone help? please.

Regards
Solway

View 6 Replies View Related

Microsoft OLE DB Provider For ODBC Drivers Error '80004005'

Oct 26, 2000

Microsoft SQL Server 6.50 - 6.50.416 (Intel X86)
Jan 23 1999 14:10:24
Copyright (c) 1988-1997 Microsoft Corporation

In a SP I generate the infor RDO in a temporate tables. When i call on ASP send this :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
/asp/rdo/rdo_mty/automatico/rdoejecutivo.asp, line 10

View 1 Replies View Related

Microsoft OLE DB Provider For ODBC Drivers Error '80040e07'

Feb 16, 2004

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

Our SQL - INSERT INTO tbl_WAAGUsage (logindate,logintime,countryname,subscriberid,ipad dress) VALUES ('2/16/2004','9:50:01 AM','Albania',62,'123456789')

Hi,

I was wondering if somebody could help me... the following error message appears when I run an asp page... I did a google search and nobody appears to have had a solution to the particular problem I have... it's completely baffling but I'm hoping it's a simple setting.

Firstly, I'm sure the coding the correct as the asp page runs on two different servers correctly. I recently got a new server and the script does not appear to work with the Date function in asp on this new server. I outputted the SQL to the browser and then ran it through the Query Analyser(QA) and guess what, it worked! But when I run the asp page the above error crops up... now when I run the SQL through QA and alter the date value in the format 'dd/mm/yyyy' the above error appears in QA.. if I've lost you at this point let me know...

The way ASP passes the Date value to my SQL DB appears to be confused and it's really confusing me as it works perfectly on two servers and not the new one... the new server runs newer versions of O/S and SQL so I'm not sure that is the case... I've changed the date settings on the server so they all three servers match each other... so I have no where else to turn... any help and pointers would be much appreciated!

Regards

Steve

View 6 Replies View Related

Microsoft OLE DB Provider For ODBC Drivers Error '80004005'

Sep 19, 2006

Hi everybodyMy problem with sql server is the following one:I've got my backoffice manager application done with asp technologythat works on sql server installed on Win2000 and running on IIS5.what I've done is simply doing a backup of my db and moving the aspapplication on another server: Windows 2003 with IIS6 and sql serververs.8.Then I tried to set up everything as in the beginning on the previousmachine(Win2K), but I'm getting this error:Microsoft OLE DB Provider for SQL Server error '80004005'[DBNETLIB][ConnectionOpen (Connect()).]Server SQL inesistente o accessonegato.(translated would be "SQL Server doesn't exist or access denied")/sitowebsite/bom/login.asp, line 13....where in the line 13 is set the connection to the database:Conn.Open Application("DBsource")which should be driven by what is set inside the global.asa file:Application("DBsource")="Provider=SQLOLEDB;server=127.0.0.1;database=db_nam e;uid=db_uid;pwd=db_pwd;"Application("WS_DB_TYPE") = ( "SQLSERVER" )I tried to restore the database just not losing information and nothinghappens.I tried also to create a new user and modify the properties as itshould be from the previous settings in the db(db_owner,....etc), stillnothing.any clue is appriciated.many thanks in advance.

View 1 Replies View Related

Microsoft OLE DB Provider For ODBC Drivers Error '80040e14'

Jul 20, 2005

Hi guys, it's nice to join the forum. Can someone can help me?After 2 years of using a program, i suddenly got this error. I triedre-installing SQL but im still getting the message.Microsoft OLE DB Provider for ODBC Drivers error '80040e14'[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot load the DLLxplog70.dll, or one of the DLLs it references. Reason: 193(error notfound).

View 1 Replies View Related

Microsoft OLE DB Provider For ODBC Drivers Error '80040e31'

Sep 24, 2007

View 5 Replies View Related

Can't Locate Microsoft OLE DB Provider For ODBC Drivers For Win Server 2003 X86

Jan 31, 2008



All,

Been serahcing frantically for this provider: "Microsoft OLE DB Provider for ODBC Drivers" for Windows Server 2003 x86. However I can't seem to find it. Supposedly MDAC 2.8 has it but when I go to install MDAC 2.8, nothing happens (this is acknowledged in fact in the support area on Microsoft and the given reason is that Win2K3 Server is already MDAC 2.8-compliant. So no new stuff needs to be installed. But alas this provider isn't in my list of available drivers).

Attempts to install any part of a lesser version of MDAC that says it has it are met with "Can't do that 'cause your current version of MDAC is higher that that."

I have been searching around all day on Msoft and other sites for such a beastie but like Brigadoon vanishing in the mist, it eludes me. Msoft's main MDAC page is here:

http://msdn2.microsoft.com/en-us/data/aa937729.aspx

We need to use this kind of driver apparently with a certain Crystal Reports report or else it just won't run.


Thanks in advance for any advice/insights/DL links that work, etc...

Matt

View 3 Replies View Related

Importing Data In MS SQL Server 2005 Using Odbc Drivers From A Remote Connection

Nov 28, 2007



hello there! i have a problem importing data from a remote connection using Sybase ASE ODBC driver(the sybase odbc driver is the only way we can access the database from the remote connection, we've already tried this in crystal reports). in the sql server import export wizard i chose the .net framework data provider for odbc. then below the wizard requires the following info: the connection string, DSN and driver. i specified the correct driver and dsn. in the connection string i specified the user id and the server name but it still produces error. the error says:

the operation could not be completed.

additional information:
ERROR[01000][SYBASE][ODBC Sybase driver][Sybase]ct_connect(): user api layer: internal Client Library error: HAFAILOVER: Trying to connect to server.
ERROR[01000][SYBASE][ODBC Sybase driver][Sybase]ct_connect(): user api layer: internal Client Library error: HAFAILOVER: Trying to connect to server.

i need your help guys... thnx

View 2 Replies View Related

Got Microsoft OLE DB Provider For ODBC Drivers Error '80004005' When Running Stored Procedures

Jan 6, 2007

when i am running a Stored Procedures, system always returns me error message below and Stored Procedures stops. please help

Microsoft OLE DB Provider for ODBC Drivers error
'80004005'

[Microsoft][ODBC SQL Server Driver] Received an unrecognized datatype 0 from
TDS data stream


sometime it returns error messge like, TDS Buffer Length Too Large
or
Unknown token received from SQL Server

or
Protocol error in TDS stream
or
Bad token from SQL Server: Datastream processing out of sync.
or
Invalid cursor state
or
TDS Buffer Link Too Large
or
Function sequence error

Many thanks, Please help, appreciated

View 4 Replies View Related

Analysis :: Can Applications Connect To SSAS Tabular Mode Cubes Through ODBC Drivers?

Aug 26, 2015

Can applications connect to SSAS Tabular mode cubes through ODBC drivers? I have been asked the question specifically regarding SAS, and I can see (for example) SAS Enterprise Guide has the ability to connect to sources via ODBC, so I now need to find out if there are such things as ODBC divers for SSAS (specifically Tabular).

View 3 Replies View Related

FYI - Executing SSIS Jobs On IA64 With 32bit Drivers

Jul 14, 2006

Just an FYI for those scheduling SSIS packages on 64bit Itaniums.
This came to light when using a 32 bit OLEDB driver on a 64bit Itanium.




When manually executing the package on the server through SQL Management
Studio, we got the expected results. However, when we scheduled the
package as a job, it failed every time. The error was:
"The AcquireConnection method call to the connection manager 'ConnectionName' failed with error code 0xC0202009€?.

We tried everything to fix this, but nothing worked. Finally we found
that when manually running the package, SQL Management Studio was calling the
32bit version of dtexec.exe, while the Agent calls the 64bit version of
dtexec.exe. The fix is to not use the "SQL Server Integration
Services Package" type in the job step, but use "Operating system
(CmdExec)" type. Then in the command box, call the 32bit (x86)
version of dtexec.exe.


Example:

C:Program Files (x86)Microsoft SQL Server90DTSBinnDTExec.exe /DTS
"File SystemSSIS Packages[PackageName]" /SERVER [SQLSERVERNAME]
/DECRYPT [password] /MAXCONCURRENT " -1 " /CHECKPOINTING OFF
/REPORTING V

View 1 Replies View Related

Integration Services :: Unable To See 64bit ODBC Driver From SSIS Odbc Connection?

Jun 1, 2015

I am using SSIS 2014 with the below .net framework version and installed in Windows server 2012 R2 . I have installed my client's odbc drivers (both 32 bit and 64 bit) in my production server and created ODBC system DSNs for 32 bit and 64 bit.

When i open SSIS 2014 and tried to create the odbc connection but i can able to see only the 32 bit system DSN connection ,i can't able to see my 64 bit odbc system dsn connection.

Microsoft Visual Studio 2012 Shell (Integrated)
Version 11.0.50727.1 RTMREL
Microsoft .NET Framework
Version 4.5.51650

SQL Server Integration Services   
Microsoft SQL Server Integration Services Designer
Version 12.0.1524.0

And i installed my client odbc drivers(32,64 bit) and created ODBC system DSNs in my local system and when i open ssis 2014 and i can able to see both the ODBC system DSNS(32,64) connections from SSIS ODBC connection.

I am using below version of .net framework in my local system which was installed in windows 7 and i have SSIS 2012 also installed in my system and i can able to see both ODBC connections using 2012 as well in my local system.

Microsoft Visual Studio 2012 Shell (Integrated)
Version 11.0.50727.1 RTMREL
Microsoft .NET Framework
Version 4.5.50938

SQL Server Integration Services   
Microsoft SQL Server Integration Services Designer
Version 12.0.1524.0

why i can not see the ODBC 64 bit system DSN connection from SSIS in my production server ?

View 9 Replies View Related

Use SSIS To Pull Data From A BASIS Database.

Oct 17, 2007

Hi All,

Anyone have any experience in connecting to a Basis database?
I want to build an SSIS package to ETL data out of a Basis database and into a sql server 2005 db.
I have downloaded the ODBC driver, but am not usre how to plug it in to SSIS to do teh extraction.

Also I am totally new to Basis...it is not an RDBMS at all but the literature says it supports SQL queries, so I am not sure about where to start.

Thanks,

Stephen

View 7 Replies View Related

Automate SSIS Package For Monthly Pull From SAP ECC 6.0

May 7, 2008

I want to automate SSIS package to pull data from SAP ECC 6.0 on monthly basis.

I am trying to use Microsoft .NET Data Provider for mySAP Business Suite which will call RFC_READ_TABLE function in SAP.

i.e.
Source
SAP Table: CE1LSC0
SAP Field: Budat (Calendar Date Field) Data Type : varchar Format: YYYYMMDD

Interface
Microsoft .NET Data Provider for mySAP Business Suite

Destination
SQL Table: TCE1LSC0

Right now I am pulling data manually from Import / Export task

SQL Script which i am to using to pull last month data:
Filter: To bring data on monthly basis ( If i run the package in May then i will like to pull data for month of April)



Code Snippet
select * from CE1LSC0
where CE1LSC0.BUDAT between 20080401 and 20080430



Now to automate
Call SAP Function Module: RFC_READ_TABLE requires following variables
@QUERY_TABLE
@DELIMITER
@OPTIONS
@FIELDS

Script:
Code SnippetEXEC rfc_name[{value | @variable [OUTPUT]}][,...n][@parameter = {value | @variable [OUTPUT]}][,...n] [;] SQL Stored Procedure to get variable: @LastMonthFirstDay , @ LastMonthLastDayCode SnippetCreate proc sp_GetDateasDECLARE @Today datetime, @FirstDay datetime , @LastDay datetime , @LastMonthFirstday int, @LastMonthLastDay intSET @Today = CAST(CONVERT(nvarchar(10), GETDATE(), 120) AS datetime) -- strips time offSET @LastDay = DATEADD(day, - DAY(@Today), @Today) -- last day of previous monthSET @FirstDay = DATEADD(month, -1, DATEADD(day, 1, @LastDay)) -- first day of previous monthset @LastMonthFirstday = Cast(Replace(Convert(varchar(10), @FirstDay, 120), '-', '') As int)--@FirstDay set @LastMonthLastDay = Cast(Replace(Convert(varchar(10), @LastDay, 120), '-', '') As int)--@LastDayselect @LastMonthFirstday as 'LastMonthFirstday', @LastMonthLastDay as 'LastMonthLastDay' My problem is that i am not able to provide my stored procedure variable to SAP RFC to automate my ssis package. Can anyone suggest something or advice how to automate my package... I have went through all the sap.net connector site and related documents but it of no use as it work with visual studio 2003 and I am using visual studio 2005 / MS SQL SERVER 2005....

View 3 Replies View Related

Ssis Cannot Pull Columns From Stored Procedure?

Sep 6, 2007



hi,

i have the following stored proc which returns a resultset at the end, i have an SSIS package that calls this stored proc and outputs the result to a file. However, the package fails because it cannot pull the columns for the schema because of the return lines in the middle of the stored proc. If i remove the it works fine, pulls hte columns as normal. but if i leave them in ssis cannot get the columns. what can i do to get around this?



ALTER PROCEDURE [dbo].[uspCreateBrightPointFile]

AS

SET nocount ON

IF EXISTS (SELECT TOP 1 *

FROM brightpointfile)

TRUNCATE TABLE brightpointfile

-- Get the order information from the database where vendorconfirmationID = 0

INSERT INTO brightpointfile

SELECT o.orderid,

o.requestid,

'295193' AS araccountnumber,

o.orderdate,

'PRIORITY' AS shipmethod,

'Asurion Dobson' AS billname,

'PO Box 110808' AS billaddress1,

'Attn Account Receivable' AS billaddress2,

' ' AS billaddress3,

'Nashville' AS billcity,

'TN' AS billstate,

'37222' AS billzip,

c.fullname AS shipname,

Replicate(' ',100) AS shipaddress1,

Replicate(' ',100) AS shipaddress2,

' ' AS shipaddress3,

Replicate(' ',40) AS shipcity,

' ' AS shipstate,

Replicate(' ',10) AS shipzip,

'1' AS linenumber,

ve.sku AS itemcode,

o.quantity AS qty,

r.typeid,

r.customerid,

0 AS addressfound

FROM [order] o WITH (NoLock)

JOIN request r WITH (NoLock)

ON o.requestid = r.requestid

JOIN customer c WITH (NoLock)

ON r.customerid = c.customerid

JOIN (SELECT [subequipid],

[subid],

[clientequipid],

[serialno],

[statusid],

[startdate],

[enddate],

[createdate],

[createuserid]

FROM subequip s1 WITH (NoLock)

WHERE s1.statusid = 1

AND s1.startdate = (SELECT MAX(s2.startdate)

FROM subequip s2 WITH (NoLock)

WHERE s2.statusid = 1

AND s2.subid = s1.subid)) se

ON r.subid = se.subid

JOIN vendorequip ve WITH (NoLock)

ON se.clientequipid = ve.clientequipid

JOIN clientequip ce WITH (NoLock)

ON ce.clientequipid = se.clientequipid

WHERE vendorconfirmationid IS NULL -- order was never sent to CellStar

AND ve.typeid IN (1) -- only pull direct fulfillment (not store fulfillment)

AND ve.vendorid IN (2) -- only pull vendor = CellStar Insurance

AND o.orderdate > '2007-08-01' -- only pull orders after 08/01/2007

--IF @@ERROR <> 0

--RETURN 1

--First use the address types of 2

UPDATE brightpointfile WITH (ROWLOCK)

SET shipaddress1 = b.address,

shipaddress2 = b.address2,

shipcity = b.city,

shipstate = b.stateid,

shipzip = b.zipcode,

addressfound = 1

FROM customeraddress a WITH (NOLOCK),

address b WITH (NOLOCK)

WHERE a.customerid = brightpointfile.customerid

AND b.addressid = a.addressid

AND a.typeid = 2

--IF @@ERROR <> 0

--RETURN 2

--Update the rest where the address type is 1 and there is no type 2

UPDATE brightpointfile WITH (ROWLOCK)

SET shipaddress1 = b.address,

shipaddress2 = b.address2,

shipcity = b.city,

shipstate = b.stateid,

shipzip = b.zipcode

FROM customeraddress a WITH (NOLOCK),

address b WITH (NOLOCK)

WHERE a.customerid = brightpointfile.customerid

AND b.addressid = a.addressid

AND a.typeid = 1

AND brightpointfile.addressfound = 0

--IF @@ERROR <> 0

--RETURN 3

--Select all the records from the temp table, plus union in 2 extra records required by the client

SELECT *

FROM (SELECT orderid,

requestid,

araccountnumber,

orderdate,

shipmethod,

billname,

billaddress1,

billaddress2,

billaddress3,

billcity,

billstate,

billzip,

shipname,

shipaddress1,

shipaddress2,

shipaddress3,

shipcity,

shipstate,

shipzip,

1 AS linenumber,

itemcode,

qty,

0 AS additional

FROM Brightpointfile WITH (nolock)

UNION ALL

SELECT orderid,

requestid,

araccountnumber,

orderdate,

shipmethod,

billname,

billaddress1,

billaddress2,

billaddress3,

billcity,

billstate,

billzip,

shipname,

shipaddress1,

shipaddress2,

shipaddress3,

shipcity,

shipstate,

shipzip,

brightpointdefaultsku.linenumber,

brightpointdefaultsku.sku,

1,

1 AS additional

FROM Brightpointdefaultsku WITH (nolock),

Brightpointfile WITH (nolock)) a

ORDER BY orderid,

additional

IF @@ERROR <> 0

RETURN 1

RETURN 0

View 3 Replies View Related

RDA Pull Problem: Command=PULL Hr=80040E4D Login Failed For User 'test'

Apr 25, 2007

Hi all,

I have following problem:

I'm developing a Windows Mobile application, which is using RDA Pull for retrieving data from SQL Server 2005 database to PDA. Please, see the example:






Code Snippet

using (SqlCeEngine engine = new SqlCeEngine(connStr))

{

engine.CreateDatabase();

}

serverConnStr="Provider=SQLOLEDB;Data Source=.;User ID=sa;Initial Catalog=Demo;Password=xxx";

using (SqlCeRemoteDataAccess rda = new SqlCeRemoteDataAccess(

Configuration.Default.SyncServerAddress, "", "", connStr))

{

rda.Pull("MyTable", "SELECT * FROM mytable", serverConnStr, RdaTrackOption.TrackingOffWithIndexes, "ErrorTable");

}





Everythink works fine, when I use 'sa' user account in serverConnStr.

But, when I change conn string to:

"Provider=SQLOLEDB;Data Source=.;User ID=test;Initial Catalog=Demo;Password=test"

the sqlcesa30.dll cannot connect to SQL Server database.

In the sqlcesa30.log then I found following line:




Code Snippet

2007/04/17 10:43:31 Thread=1EE30 RSCB=16 Command=PULL Hr=80040E4D Login failed for user 'test'. 18456



The user 'test' is member of db_owner, db_datareader and public roles for the Demo database and in SQL Server Management Studio I'm able to login to the Demo database with using the 'test' users credentials and I'm able to run the select command on 'mytable'.



So, what's wrong? Why the sqlcesa30.dll process cannot login to the Demo database, and from another application with using the SAME connection string it works?



Please help.



Thank you.

Fipil.



View 10 Replies View Related

SQL Server 2008 :: Using SSIS To Pull Oracle Data Into XML Field

Jul 1, 2015

We have a custom web C#/SQL2K8R2 workflow application that I need to pull Oracle data into a varchar(max) field as an XML DOM document. I have no problem pulling the Oracle data using OLEDB, but I'm not sure how to create the XML DOM doc. Once I get it into the DOM doc, I then need to assign metadata about the XML DOM doc and insert it all into a staging table:

CREATE TABLE [stg].[EtlImports](
[EtlImportId] [int] IDENTITY(1,1) NOT NULL,
[EtlSource] [varchar](50) NOT NULL,
[EtlType] [varchar](50) NULL,
[EtlDefn] [varchar](max) NULL, --Either a SQL statement or path to file on disk
[EtlData] [varchar](max) NULL, --BLOB field to hold the XML data or FILESTREAM path to file on disk
[EtlDateLanded] [datetime] NOT NULL,
[EtlDateProcessed] [datetime] NULL,
[EtlStatus] [varchar](50) NULL,
[Comments] [varchar](4000) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

I will have a separate SSIS package to pull the [XML/File] field and process the data into the workflow tables. Is there a wasy I can use the ADO Record-set Destination task to accomplish this, or do I have to create a custom C# script to create the XML DOM Doc?

View 0 Replies View Related

SQL Server 2008 :: SSIS Script Task To Pull AD UserAccountControl?

Jul 24, 2015

I am trying to pull AD users and their attributes to a SQL server table.

I am using the script task in SSIS. (I don't use openquery and linkedserver for that is not applied to our case).

I can pull most of columns, but there are some columns like below are so hard to pull:

, [Disabled]
,[AccountLockedOut]
,[CannotChangePassword]
,[PWNeverExpire]
,[PasswordNotRequired]

I did some research and find they are all in the userAccountControl attribute.

So I did something like below

If (results.Properties.Contains("userAccountControl")) Disabled = results.Properties["userAccountControl"][0].ToString();

But found all values I got is 1. That is not correct.

By reading this, it should return some values like mentioned in this

[URL]

View 0 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved