IMEX=1 and 'No Value for give parameter'

#1

Hi
I am porting data from excel to text file , I am using the
famous IMEX=1 parameter so that I can port hybrid data.
In the data pump I have used a query which will help me in
truncating the data something like this
select F1,F2,Left(F3,240) FROM SHEET1$

I am getting the following error
'No Value Given For One Or More required Parameter'
Cant Figure out what is missing

Ravi

#2

Hi Allan,
Excel 2002 (9.0.2720) SQL Server 2000
I believe the problem is in the query because when I
select 3-4 Columns its fine when
Also when I do
SELECT left(F38,240) AS F38
FROM SHEET1$
It parses fine and maps fine but when I execute is says
source for F38 Unknow .. But If I remove IMEX=1 It ports
fine

Ravi

#3

So how many columns are you using ?
Is there a break point ?

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Ravi" <rravi3 (AT) Covansys (DOT) com> wrote

Quote:

Hi Allan,
Excel 2002 (9.0.2720) SQL Server 2000
I believe the problem is in the query because when I
select 3-4 Columns its fine when
Also when I do
SELECT left(F38,240) AS F38
FROM SHEET1$
It parses fine and maps fine but when I execute is says
source for F38 Unknow .. But If I remove IMEX=1 It ports
fine

Ravi

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

IMEX=1 and 'No Value for give parameter'

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

IMEX=1 and 'No Value for give parameter' - 08-13-2003 , 04:32 AM

Re: IMEX=1 and 'No Value for give parameter' - 08-13-2003 , 05:09 AM

Re: IMEX=1 and 'No Value for give parameter' - 08-13-2003 , 05:35 AM