Click here to Skip to main content
14,841,844 members
Home / Discussions / Database
   

Database

 
QuestionSSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209302 Pin
indian14311-Oct-17 7:36
Memberindian14311-Oct-17 7:36 
QuestionSQL Server store procedure and prevent sql injection Pin
Mou_kol6-Oct-17 8:45
MemberMou_kol6-Oct-17 8:45 
AnswerRe: SQL Server store procedure and prevent sql injection Pin
Richard Deeming6-Oct-17 9:27
mveRichard Deeming6-Oct-17 9:27 
GeneralRe: SQL Server store procedure and prevent sql injection Pin
Mou_kol6-Oct-17 11:30
MemberMou_kol6-Oct-17 11:30 
GeneralRe: SQL Server store procedure and prevent sql injection Pin
Eddy Vluggen7-Oct-17 2:22
professionalEddy Vluggen7-Oct-17 2:22 
GeneralRe: SQL Server store procedure and prevent sql injection Pin
Richard Deeming9-Oct-17 8:59
mveRichard Deeming9-Oct-17 8:59 
GeneralRe: SQL Server store procedure and prevent sql injection Pin
MadMyche22-Nov-17 4:13
mveMadMyche22-Nov-17 4:13 
QuestionImporting the integer values that are coming within " Pin
indian1435-Oct-17 14:14
Memberindian1435-Oct-17 14:14 
Hi,

I am getting a flat file that's getting number values like integer and decimal values also withing "" like id is also coming as "1" or "100" etc, so in ssis package in Data Conversion its failing, can I get any expression or something to eliminate those double quotes and import the value into the Database with proper conversion everything.

I am getting the error message as below:
FileFullName: \\xxxxx\\DataExchange\ShieldLink\Test\32 Bit and 64 Bit Testing\Thirty Two Bit.csv, SSISPackageName: ImportPipeDelimitedCSV.dtsx, Source : Microsoft.SqlServer.Dts.Runtime.TaskHost, ErrorCode : -1071607767, Description : SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "Data Conversion.Outputs[Data Conversion Output].Columns[Copy of Column1]" failed because error code 0xC020907F occurred, and the error row disposition on "Data Conversion.Outputs[Data Conversion Output].Columns[Copy of Column1]" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.
, SubComponent: Data Conversion [2], HelpFiledtsmsg110.rll, HelpContext0, IdofInterfaceWithError{B6F6D221-FC27-4F71-B5A0-597583986C28}

This is failing because the values are coming as below:
Column1|Column2|Column3|
"1"|"Column 2 Value 1"|"Column 3 Value 1"

For texts its able to convert properly but for the numerical values its failing is there anything that I can do to eliminate those " and implement Data conversion without any problems thanks in advance.

But in some situations I get this error, I am not sure why is this error coming, could it lead to not load data, sometimes even with this warning also we are able to load the Data I think so, but I am not sure, the Warning is as below:
FileFullName: \\xxxxx\ShieldLink\Test\32 Bit and 64 Bit Testing\Thirty Two Bit.csv, SSISPackageName: ImportPipeDelimitedCSV.dtsx, Source : Microsoft.SqlServer.Dts.Runtime.TaskHost, WarningCode : -2147183868, Description : Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available.  To resolve, run this package as an administrator, or on the system's console.
, SubComponent: SSIS.Pipeline, HelpFiledtsmsg110.rll, HelpContext0, IdofInterfaceWithError{B6F6D221-FC27-4F71-B5A0-597583986C28}

I am not understanding is it a Data conversion issue or some other privileges issue, any help would be greatly helpful, thanks in advance friends.

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."

-- modified 5-Oct-17 20:31pm.
AnswerRe: Importing the integer values that are coming within " Pin
jschell6-Oct-17 7:18
Memberjschell6-Oct-17 7:18 
QuestionYou cannot install the 64-bit version of Microsoft Access Database Engine 2016 because you currently have 32-bit Office Products installed Pin
indian1432-Oct-17 11:49
Memberindian1432-Oct-17 11:49 
QuestionRe: You cannot install the 64-bit version of Microsoft Access Database Engine 2016 because you currently have 32-bit Office Products installed Pin
Richard MacCutchan2-Oct-17 21:53
mveRichard MacCutchan2-Oct-17 21:53 
AnswerRe: You cannot install the 64-bit version of Microsoft Access Database Engine 2016 because you currently have 32-bit Office Products installed Pin
jschell4-Oct-17 7:53
Memberjschell4-Oct-17 7:53 
QuestionHow Commonly used are the dotNet Datatables and Datasets? Pin
MarcusCole683328-Sep-17 6:06
professionalMarcusCole683328-Sep-17 6:06 
AnswerRe: How Commonly used are the dotNet Datatables and Datasets? Pin
Eddy Vluggen28-Sep-17 6:58
professionalEddy Vluggen28-Sep-17 6:58 
AnswerRe: How Commonly used are the dotNet Datatables and Datasets? Pin
Richard MacCutchan28-Sep-17 9:45
mveRichard MacCutchan28-Sep-17 9:45 
AnswerRe: How Commonly used are the dotNet Datatables and Datasets? Pin
Mycroft Holmes28-Sep-17 14:08
professionalMycroft Holmes28-Sep-17 14:08 
Questionhow to get the music database for my website? Pin
Member 1322076227-Sep-17 7:57
MemberMember 1322076227-Sep-17 7:57 
AnswerRe: how to get the music database for my website? Pin
OriginalGriff27-Sep-17 8:00
mveOriginalGriff27-Sep-17 8:00 
GeneralRe: how to get the music database for my website? Pin
Member 1322076224-Nov-17 19:08
MemberMember 1322076224-Nov-17 19:08 
AnswerRe: how to get the music database for my website? Pin
jschell27-Sep-17 9:28
Memberjschell27-Sep-17 9:28 
QuestionSSIS Packages are running on Staging but not on the Production Server - little bit Urgent my friends Pin
indian14326-Sep-17 6:34
Memberindian14326-Sep-17 6:34 
AnswerRe: SSIS Packages are running on Staging but not on the Production Server Pin
Eddy Vluggen27-Sep-17 3:35
professionalEddy Vluggen27-Sep-17 3:35 
AnswerRe: SSIS Packages are running on Staging but not on the Production Server Pin
jschell27-Sep-17 9:31
Memberjschell27-Sep-17 9:31 
QuestionNeed to find out what drivers are missing on the Production Server Pin
indian14321-Sep-17 7:32
Memberindian14321-Sep-17 7:32 
AnswerRe: Need to find out what drivers are missing on the Production Server Pin
Eddy Vluggen21-Sep-17 23:23
professionalEddy Vluggen21-Sep-17 23:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.