Click here to Skip to main content
15,883,901 members
Home / Discussions / Database
   

Database

 
GeneralRe: Pump wait message while accessing data Pin
Mike Dimmick7-Mar-08 10:20
Mike Dimmick7-Mar-08 10:20 
QuestionAdding static column to matix in SSRS.. PLz Help !! [modified] Pin
Payal_e_m6-Mar-08 14:17
Payal_e_m6-Mar-08 14:17 
GeneralRe: Adding static column to matix in SSRS.. PLz Help !! Pin
pmarfleet6-Mar-08 21:05
pmarfleet6-Mar-08 21:05 
QuestionRe: Adding static column to matix in SSRS.. PLz Help !! Pin
Payal_e_m10-Mar-08 10:59
Payal_e_m10-Mar-08 10:59 
GeneralRe: Adding static column to matix in SSRS.. PLz Help !! Pin
Payal_e_m10-Mar-08 17:49
Payal_e_m10-Mar-08 17:49 
QuestionSetting a Grobal Variable from a Stored Procedure in SSIS Pin
ONeil Tomlinson6-Mar-08 1:00
ONeil Tomlinson6-Mar-08 1:00 
GeneralRe: Setting a Grobal Variable from a Stored Procedure in SSIS Pin
SimulationofSai6-Mar-08 1:46
SimulationofSai6-Mar-08 1:46 
GeneralRe: Setting a Grobal Variable from a Stored Procedure in SSIS Pin
ONeil Tomlinson6-Mar-08 2:58
ONeil Tomlinson6-Mar-08 2:58 
Im using OLEDB
Ive configured the properties as you said

Variable Name = User::intError
Direction = Output
Data Type = Long_Integer (global variable is expecting an int32)
Parameter Name = 0

but whe i run i get the following

##############################################
--Execute Stored procedure
EXEC ? = sp_delete_temp_people_import_tables

" failed with the following error: "Syntax error, permission violation, or other nonspecific error". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Execute SQL Task
################################################

When i try parsing it before i ran the package i get the same error as above - "Syntax error, permission violation, or other nonspecific error".
GeneralRe: Setting a Grobal Variable from a Stored Procedure in SSIS Pin
SimulationofSai6-Mar-08 3:31
SimulationofSai6-Mar-08 3:31 
GeneralRe: Setting a Grobal Variable from a Stored Procedure in SSIS Pin
ONeil Tomlinson6-Mar-08 3:49
ONeil Tomlinson6-Mar-08 3:49 
GeneralRe: Setting a Grobal Variable from a Stored Procedure in SSIS Pin
ONeil Tomlinson6-Mar-08 5:39
ONeil Tomlinson6-Mar-08 5:39 
GeneralRe: Setting a Grobal Variable from a Stored Procedure in SSIS Pin
SimulationofSai6-Mar-08 6:34
SimulationofSai6-Mar-08 6:34 
GeneralRe: Setting a Grobal Variable from a Stored Procedure in SSIS Pin
ONeil Tomlinson6-Mar-08 9:09
ONeil Tomlinson6-Mar-08 9:09 
GeneralRe: Setting a Grobal Variable from a Stored Procedure in SSIS Pin
SimulationofSai6-Mar-08 9:17
SimulationofSai6-Mar-08 9:17 
QuestionDatabase Independent Application for Bulk Sale/ Distribution Pin
JayKhatri6-Mar-08 0:54
JayKhatri6-Mar-08 0:54 
GeneralRe: Database Independent Application for Bulk Sale/ Distribution Pin
GuyThiebaut6-Mar-08 1:22
professionalGuyThiebaut6-Mar-08 1:22 
GeneralField Expressions in Sql Server Reporting Srevices(SSRS)-2005.. Pin
Aswanth6-Mar-08 0:11
Aswanth6-Mar-08 0:11 
GeneralRe: Field Expressions in Sql Server Reporting Srevices(SSRS)-2005.. Pin
pmarfleet6-Mar-08 2:00
pmarfleet6-Mar-08 2:00 
GeneralRe: Field Expressions in Sql Server Reporting Srevices(SSRS)-2005.. Pin
Aswanth6-Mar-08 20:11
Aswanth6-Mar-08 20:11 
GeneralRe: Field Expressions in Sql Server Reporting Srevices(SSRS)-2005.. Pin
pmarfleet6-Mar-08 20:49
pmarfleet6-Mar-08 20:49 
Generalgeneralized/generic stored procedures Pin
mamatha_raghu6-Mar-08 0:08
mamatha_raghu6-Mar-08 0:08 
GeneralRe: generalized/generic stored procedures Pin
Mike Dimmick7-Mar-08 10:27
Mike Dimmick7-Mar-08 10:27 
GeneralUsing existed Database file. Pin
Hum Dum5-Mar-08 23:51
Hum Dum5-Mar-08 23:51 
GeneralRe: Using existed Database file. Pin
GuyThiebaut6-Mar-08 1:31
professionalGuyThiebaut6-Mar-08 1:31 
GeneralRe: Using existed Database file. Pin
Hum Dum6-Mar-08 19:59
Hum Dum6-Mar-08 19:59 

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.