HomeForum
Welcome, Guest

Package doesn't work
(1 viewing) (1) Guest
  • Page:
  • 1
  • 2

TOPIC: Package doesn't work

Package doesn't work 8 months, 2 weeks ago #3737

  • Marek
  • OFFLINE
  • Fresh Boarder
  • Posts: 10
  • Karma: 0
I have crated a package wchich contains just data import. I marked it as a start point. When I Execute this package it shows me that everythink was ok and in is finished.
This data import include SQL before wchich truncate me table and after that send my data from TXT files. After finish I have empty tables but there is no data from TXT.
When I execute just data import it works fine and I have firstly empty table and after that all data from TXT files.

Please halp me.
Attachments:

Re: Package doesn't work 8 months, 2 weeks ago #3738

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2191
  • Karma: 12
Right click on the object and select the starting point.

If it does not help post here the logs

Mike

Re: Package doesn't work 8 months, 2 weeks ago #3740

  • Marek
  • OFFLINE
  • Fresh Boarder
  • Posts: 10
  • Karma: 0
It doesn't work. Here is log:

Information 2011-09-09 14:24:46 Preparing to execute Wysyla cos
Information 2011-09-09 14:24:46 Package Started
Information 2011-09-09 14:24:46 Executing Import Script: wysyla 5km na mysql
Information 2011-09-09 14:24:46 Source File(s): C:\Documents and Settings\Administrator\Pulpit\Maraton Warszawski\
Information 2011-09-09 14:24:47 Processed: 0 Records
Information 2011-09-09 14:24:47 Errors:
Information 2011-09-09 14:24:47 Records per second: 10
Information 2011-09-09 14:24:47 Execution of Import Script: wysyla 5km na mysql has completed
Information 2011-09-09 14:24:47 Package Finished

Regards
Marek

Re: Package doesn't work 8 months, 2 weeks ago #3741

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2191
  • Karma: 12
Double click on the object within the package and select the file to import data from

Mike

Re: Package doesn't work 8 months, 2 weeks ago #3742

  • Marek
  • OFFLINE
  • Fresh Boarder
  • Posts: 10
  • Karma: 0
strange or normal? I typed a file direction: C:\Documents and Settings\Administrator\Pulpit\Maraton Warszawski\5_LOG.txt into Advanced\Files to load --> attachement. Now it's fine? I have to do it all the time?

Rgs.
Marek
Attachments:

Re: Package doesn't work 8 months, 2 weeks ago #3743

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2191
  • Karma: 12
When you design the Import you may want yo quickly load the from the different file.
But you will not want the package you use everyday to load data from this file.

That is the reason
Mike
  • Page:
  • 1
  • 2
Time to create page: 0.21 seconds

Testimonials

"In my personal view, currently there are no other data transformation tools on the market that provide the same value for money as Advanced ETL Processor. The number of features is constantly increasing and If something is missing the will add it for you  ..."

Gabriell Mellotto, Senior ETL Consultant

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top