I have a DB connection and a output destination defined in my SSIS package.
What creates the output file is driven from a query that uses a view
to extarct the records to the Flat file. If I run this query it returns the
records with 20 seconds. When I let it run thru the package it never opens
the output file or appears to be doing anything except running the CPU thru
the roof.

any ideas to what is causing this issue?

Sql2005(sp2).


Thanks.

On Jun 12, 12:21 am, "AHartman" <Hoosbr... (AT) Kconline (DOT) com> wrote:
Hi Ahartman, you must provide us more infos.
Did the package end up with an error? If yes, which error? Or it works
without creating the file?
Or more likely it seems to be running but after some minutes you have
to kill/stop it.

In any case, if a query normal execution (i mean with query analyzer
or management studio) takes 20 secs to get all records this could mean
that (1) the query is quite complex or (2) the query retrieves so many
rows...
and writing records to a flat file is much slower that getting it
through a query in management studio.

Please let us know,
M.

On Jun 12, 12:21 am, "AHartman" <Hoosbr... (AT) Kconline (DOT) com> wrote:
Hi Ahartman, you must provide us more infos.
Did the package end up with an error? If yes, which error? Or it works
without creating the file?
Or more likely it seems to be running but after some minutes you have
to kill/stop it.

In any case, if a query normal execution (i mean with query analyzer
or management studio) takes 20 secs to get all records this could mean
that (1) the query is quite complex or (2) the query retrieves so many
rows...
and writing records to a flat file is much slower that getting it
through a query in management studio.

Please let us know,
M.

On Jun 12, 12:21 am, "AHartman" <Hoosbr... (AT) Kconline (DOT) com> wrote:
Hi Ahartman, you must provide us more infos.
Did the package end up with an error? If yes, which error? Or it works
without creating the file?
Or more likely it seems to be running but after some minutes you have
to kill/stop it.

In any case, if a query normal execution (i mean with query analyzer
or management studio) takes 20 secs to get all records this could mean
that (1) the query is quite complex or (2) the query retrieves so many
rows...
and writing records to a flat file is much slower that getting it
through a query in management studio.

Please let us know,
M.

On Jun 12, 12:21 am, "AHartman" <Hoosbr... (AT) Kconline (DOT) com> wrote:
Hi Ahartman, you must provide us more infos.
Did the package end up with an error? If yes, which error? Or it works
without creating the file?
Or more likely it seems to be running but after some minutes you have
to kill/stop it.

In any case, if a query normal execution (i mean with query analyzer
or management studio) takes 20 secs to get all records this could mean
that (1) the query is quite complex or (2) the query retrieves so many
rows...
and writing records to a flat file is much slower that getting it
through a query in management studio.

Please let us know,
M.

On Jun 12, 12:21 am, "AHartman" <Hoosbr... (AT) Kconline (DOT) com> wrote:
Hi Ahartman, you must provide us more infos.
Did the package end up with an error? If yes, which error? Or it works
without creating the file?
Or more likely it seems to be running but after some minutes you have
to kill/stop it.

In any case, if a query normal execution (i mean with query analyzer
or management studio) takes 20 secs to get all records this could mean
that (1) the query is quite complex or (2) the query retrieves so many
rows...
and writing records to a flat file is much slower that getting it
through a query in management studio.

Please let us know,
M.

On Jun 12, 12:21 am, "AHartman" <Hoosbr... (AT) Kconline (DOT) com> wrote:
Hi Ahartman, you must provide us more infos.
Did the package end up with an error? If yes, which error? Or it works
without creating the file?
Or more likely it seems to be running but after some minutes you have
to kill/stop it.

In any case, if a query normal execution (i mean with query analyzer
or management studio) takes 20 secs to get all records this could mean
that (1) the query is quite complex or (2) the query retrieves so many
rows...
and writing records to a flat file is much slower that getting it
through a query in management studio.

Please let us know,
M.

On Jun 12, 12:21 am, "AHartman" <Hoosbr... (AT) Kconline (DOT) com> wrote:
Hi Ahartman, you must provide us more infos.
Did the package end up with an error? If yes, which error? Or it works
without creating the file?
Or more likely it seems to be running but after some minutes you have
to kill/stop it.

In any case, if a query normal execution (i mean with query analyzer
or management studio) takes 20 secs to get all records this could mean
that (1) the query is quite complex or (2) the query retrieves so many
rows...
and writing records to a flat file is much slower that getting it
through a query in management studio.

Please let us know,
M.

On Jun 12, 12:21 am, "AHartman" <Hoosbr... (AT) Kconline (DOT) com> wrote:
Hi Ahartman, you must provide us more infos.
Did the package end up with an error? If yes, which error? Or it works
without creating the file?
Or more likely it seems to be running but after some minutes you have
to kill/stop it.

In any case, if a query normal execution (i mean with query analyzer
or management studio) takes 20 secs to get all records this could mean
that (1) the query is quite complex or (2) the query retrieves so many
rows...
and writing records to a flat file is much slower that getting it
through a query in management studio.

Please let us know,
M.